APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on JL_BR_SPED_EXTR_MSGS

Line 7750: INSERT INTO jl_br_sped_extr_msgs

7746: IF l_cnt > 0 THEN
7747:
7748:
7749: FND_MESSAGE.SET_NAME('JL','JLBR_SPED_SOMA_SALDO_INICIAL');
7750: INSERT INTO jl_br_sped_extr_msgs
7751: (request_id,
7752: block,
7753: register,
7754: field,

Line 7818: INSERT INTO jl_br_sped_extr_msgs

7814: AND field8 <>'0,00';
7815:
7816: IF l_cnt > 0 THEN
7817: FND_MESSAGE.SET_NAME('JL','JLBR_SPED_SOMA_SALDO_FINAL');
7818: INSERT INTO jl_br_sped_extr_msgs
7819: (request_id,
7820: block,
7821: register,
7822: field,

Line 7889: INSERT INTO jl_br_sped_extr_msgs

7885: AND field6 <> field7;
7886:
7887: IF l_cnt > 0 THEN
7888: FND_MESSAGE.SET_NAME('JL','JLBR_SPED_DEB_DIF_CRED');
7889: INSERT INTO jl_br_sped_extr_msgs
7890: (request_id,
7891: block,
7892: register,
7893: field,

Line 7966: INSERT INTO jl_br_sped_extr_msgs

7962: );
7963:
7964: IF l_cnt > 0 THEN
7965: FND_MESSAGE.SET_NAME('JL','JLBR_SPED_VALOR_DEB');
7966: INSERT INTO jl_br_sped_extr_msgs
7967: (request_id,
7968: block,
7969: register,
7970: field,

Line 8044: INSERT INTO jl_br_sped_extr_msgs

8040:
8041:
8042: IF l_cnt > 0 THEN
8043: FND_MESSAGE.SET_NAME('JL','JLBR_SPED_VALOR_CRED');
8044: INSERT INTO jl_br_sped_extr_msgs
8045: (request_id,
8046: block,
8047: register,
8048: field,

Line 8118: INSERT INTO jl_br_sped_extr_msgs

8114: MIN(to_number(I200.field4,'99999999999999990D00','NLS_NUMERIC_CHARACTERS = '',.'''));
8115:
8116: IF l_cnt >0 THEN
8117: FND_MESSAGE.SET_NAME('JL','JLBR_SPED_VL_LCTO_DEB');
8118: INSERT INTO jl_br_sped_extr_msgs
8119: (request_id,
8120: block,
8121: register,
8122: field,

Line 8190: INSERT INTO jl_br_sped_extr_msgs

8186: min(to_number(I200.field4,'99999999999999990D00','NLS_NUMERIC_CHARACTERS = '',.'''));
8187:
8188: IF l_cnt <>0 THEN
8189: FND_MESSAGE.SET_NAME('JL','JLBR_SPED_VL_LCTO_CRED');
8190: INSERT INTO jl_br_sped_extr_msgs
8191: (request_id,
8192: block,
8193: register,
8194: field,

Line 8278: INSERT INTO jl_br_sped_extr_msgs

8274: AND field4 <> field5;
8275:
8276: IF l_cnt <> 0 THEN
8277: FND_MESSAGE.SET_NAME('JL','JLBR_SPED_DC_BALANCETE');
8278: INSERT INTO jl_br_sped_extr_msgs
8279: (request_id,
8280: block,
8281: register,
8282: field,

Line 8341: INSERT INTO jl_br_sped_extr_msgs

8337: IF l_cnt < 1 THEN
8338:
8339: FND_MESSAGE.SET_NAME('JL','JLBR_SPED_ASSIN_CONTADOR');
8340:
8341: INSERT INTO jl_br_sped_extr_msgs
8342: (request_id,
8343: block,
8344: register,
8345: field,

Line 8382: INSERT INTO jl_br_sped_extr_msgs

8378:
8379: IF l_cnt < 1 THEN
8380:
8381: FND_MESSAGE.SET_NAME('JL','JLBR_SPED_ASSIN_CONTADOR');
8382: INSERT INTO jl_br_sped_extr_msgs
8383: (request_id,
8384: block,
8385: register,
8386: field,

Line 8558: FROM jl_br_sped_extr_msgs

8554: non_printable_chars varchar2(35):='|';
8555: l_cnt NUMBER;
8556: l_sequence_value NUMBER;
8557: /*CURSOR msg_cur IS SELECT message_txt,validation_rule
8558: FROM jl_br_sped_extr_msgs
8559: WHERE request_id = g_concurrent_request_id ;*/
8560:
8561: CURSOR accts_with_invalid_jrl_amounts IS
8562: SELECT field2 natural_acct