APPS.GL_COA_SEG_VAL_IMP_PKG dependencies on FND_MSG_PUB

Line 79: FND_MSG_PUB.ADD;

75: FND_MESSAGE.SET_NAME('GL',p_c_msg_name);
76: IF p_c_token IS NOT NULL THEN
77: FND_MESSAGE.SET_TOKEN('PARAM',p_c_token);
78: END IF;
79: FND_MSG_PUB.ADD;
80:
81: END set_msg;
82:
83: --Create process for fnd_flex_values

Line 190: fnd_msg_pub.add;

186: EXCEPTION
187: WHEN E_RESOURCE_BUSY THEN
188: CLOSE c_fnd_flex_values;
189: fnd_message.set_name( 'GL', 'GL_COA_SVI_REC_LOCK');
190: fnd_msg_pub.add;
191: gl_coa_flex_values_rec.status := 'E';
192:
193: END check_insert_update;
194:

Line 309: fnd_msg_pub.add;

305: END IF;
306:
307: IF gl_coa_flex_values_rec.account_type IS NOT NULL AND gl_coa_flex_values_rec.account_type NOT IN ('A','L','R','E','O') THEN
308: fnd_message.set_name('GL','GL_COA_SVI_INV_AC_TYPE');
309: fnd_msg_pub.add;
310: gl_coa_flex_values_rec.status := 'E';
311: END IF;
312:
313: IF gl_coa_flex_values_rec.reconcile IS NOT NULL AND gl_coa_flex_values_rec.reconcile NOT IN ('N','Y') THEN

Line 382: p_gl_flex_values_tbl(I).msg_from := fnd_msg_pub.count_msg;

378: FOR I in 1..p_gl_flex_values_tbl.LAST LOOP
379: IF p_gl_flex_values_tbl.EXISTS(I) THEN
380:
381: p_gl_flex_values_tbl(I).status := 'S';
382: p_gl_flex_values_tbl(I).msg_from := fnd_msg_pub.count_msg;
383: trim_values(p_gl_flex_values_tbl(I) );
384:
385: -- DRM Change: Added IF condition, fetch value set properties for the first value
386: -- and after that only when value-set changes

Line 602: fnd_msg_pub.add;

598: ||p_gl_flex_values_tbl(I).flex_value||' '||'Error_Message:'||FND_MESSAGE.GET
599: ||' '||'Unhandled Exception :'||sqlerrm);
600: END IF;
601: fnd_message.set_name( 'GL', 'GL_COA_SVI_FLEX_UN_EX');
602: fnd_msg_pub.add;
603: p_gl_flex_values_tbl(I).status := 'E';
604: END;
605:
606: END IF;--insert/update

Line 625: p_gl_flex_values_tbl(I).msg_to := fnd_msg_pub.count_msg;

621: IF p_c_rec_status = 'S' THEN
622: p_c_rec_status := p_gl_flex_values_tbl(I).status;
623: END IF;
624: p_gl_flex_values_tbl(I).msg_from := p_gl_flex_values_tbl(I).msg_from+1;
625: p_gl_flex_values_tbl(I).msg_to := fnd_msg_pub.count_msg;
626: IF p_gl_flex_values_tbl(I).status = 'E' THEN
627: NULL;--RETURN;
628: END IF;
629: END IF;

Line 662: fnd_msg_pub.add;

658: ||p_gl_flex_values_tbl(I).flex_value||' '||'Value_set_id:'||TO_CHAR(flex_vl_set_id_tab(i))||' '||'Error_Message:'||
659: FND_MESSAGE.GET);
660: END IF;
661: fnd_message.set_name ( 'GL', 'GL_COA_SVI_COM_HIER_ERR' );
662: fnd_msg_pub.add;
663: END IF;
664: END LOOP;
665:
666: flex_vl_set_id_tab.delete;

Line 727: fnd_msg_pub.add;

723: FETCH c_fnd_flex_values INTO l_cur_co;
724: IF c_fnd_flex_values%NOTFOUND THEN
725: CLOSE c_fnd_flex_values;
726: fnd_message.set_name('GL','GL_COA_SVI_INVALID_VALUE');
727: fnd_msg_pub.add;
728: gl_coa_flex_values_nh_rec.status := 'E';
729: ELSE
730: CLOSE c_fnd_flex_values;
731: END IF;

Line 817: fnd_msg_pub.add;

813:
814: -- Child Flex Value Low should be less than Child Flex Value high
815: IF gl_coa_flex_values_nh_rec.child_flex_value_low > gl_coa_flex_values_nh_rec.child_flex_value_high THEN
816: fnd_message.set_name('GL','GL_COA_SVI_CFH_LESS_CFL');
817: fnd_msg_pub.add;
818: gl_coa_flex_values_nh_rec.status := 'E';
819: END IF;
820:
821: --Loop detected if Range Attribute is 'P' and the parent flex value falls in between child_flex_value_low and child_flex_value_high

Line 845: p_gl_flex_values_nh_tbl(I).msg_from := fnd_msg_pub.count_msg;

841: FOR I in 1..p_gl_flex_values_nh_tbl.LAST LOOP
842: IF p_gl_flex_values_nh_tbl.EXISTS(I) THEN
843:
844: p_gl_flex_values_nh_tbl(I).status := 'S';
845: p_gl_flex_values_nh_tbl(I).msg_from := fnd_msg_pub.count_msg;
846: trim_values(p_gl_flex_values_nh_tbl(I) );
847: -- DRM Change: Added IF condition, fetch value set properties for the first value
848: -- and after that only when value-set changes
849: IF I=1 OR l_cur_co.flex_value_set_name = p_gl_flex_values_nh_tbl(I).value_set_name

Line 932: fnd_msg_pub.add;

928: AND range_attribute= p_gl_flex_values_nh_tbl(I).range_attribute;
929: EXCEPTION
930: WHEN OTHERS THEN
931: fnd_message.set_name( 'GL', 'GL_COA_SVI_FLEX_UN_EX');
932: fnd_msg_pub.add;
933: p_gl_flex_values_nh_tbl(I).status := 'E';
934: END;
935: END IF;
936:

Line 954: p_gl_flex_values_nh_tbl(I).msg_to := fnd_msg_pub.count_msg;

950: IF p_c_rec_status = 'S' THEN
951: p_c_rec_status := p_gl_flex_values_nh_tbl(I).status;
952: END IF;
953: p_gl_flex_values_nh_tbl(I).msg_from := p_gl_flex_values_nh_tbl(I).msg_from+1;
954: p_gl_flex_values_nh_tbl(I).msg_to := fnd_msg_pub.count_msg;
955: IF p_gl_flex_values_nh_tbl(I).status = 'E' THEN
956: NULL;--RETURN;
957: END IF;
958: END IF;

Line 983: fnd_msg_pub.add;

979: '', '', '', '', '', '', '', '', '', '',
980: '', '', '', '', '', '', '', '', '', '');
981: IF (req_id = 0) THEN
982: fnd_message.set_name ( 'GL', 'GL_COA_SVI_COM_HIER_ERR' );
983: fnd_msg_pub.add;
984: END IF;
985: END LOOP;
986:
987: flex_vl_set_id_tab.delete;