eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on FND_MESSAGE

Line 967: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');

963: IF p_cc_limit_used <> 'ITEM' THEN
964: -- bug 4002820
965: IF INSTR(p_cc_limit_used, ',') > 0 THEN
966: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
967: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
968: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
969: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
970: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
971: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);

Line 968: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);

964: -- bug 4002820
965: IF INSTR(p_cc_limit_used, ',') > 0 THEN
966: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
967: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
968: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
969: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
970: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
971: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
972: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

Line 969: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);

965: IF INSTR(p_cc_limit_used, ',') > 0 THEN
966: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
967: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
968: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
969: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
970: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
971: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
972: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
973: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');

Line 970: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

966: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
967: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
968: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
969: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
970: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
971: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
972: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
973: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
974: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);

Line 971: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);

967: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
968: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
969: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
970: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
971: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
972: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
973: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
974: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
975: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);

Line 972: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

968: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
969: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
970: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
971: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
972: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
973: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
974: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
975: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
976: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

Line 973: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');

969: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
970: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
971: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
972: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
973: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
974: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
975: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
976: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
977: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);

Line 974: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);

970: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
971: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
972: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
973: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
974: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
975: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
976: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
977: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
978: OE_MSG_PUB.Add;

Line 975: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);

971: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
972: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
973: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
974: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
975: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
976: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
977: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
978: OE_MSG_PUB.Add;
979:

Line 976: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

972: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
973: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
974: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
975: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
976: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
977: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
978: OE_MSG_PUB.Add;
979:
980: ELSE

Line 977: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);

973: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
974: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
975: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
976: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
977: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
978: OE_MSG_PUB.Add;
979:
980: ELSE
981: IF p_cc_profile_used = 'SITE' THEN

Line 982: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

978: OE_MSG_PUB.Add;
979:
980: ELSE
981: IF p_cc_profile_used = 'SITE' THEN
982: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
983: p_cc_profile_used);
984: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
985: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
986: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);

Line 984: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);

980: ELSE
981: IF p_cc_profile_used = 'SITE' THEN
982: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
983: p_cc_profile_used);
984: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
985: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
986: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
987: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
988: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

Line 985: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);

981: IF p_cc_profile_used = 'SITE' THEN
982: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
983: p_cc_profile_used);
984: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
985: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
986: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
987: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
988: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
989:

Line 986: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);

982: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
983: p_cc_profile_used);
984: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
985: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
986: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
987: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
988: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
989:
990: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 987: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);

983: p_cc_profile_used);
984: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
985: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
986: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
987: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
988: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
989:
990: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
991: p_cc_profile_used);

Line 988: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

984: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
985: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
986: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
987: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
988: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
989:
990: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
991: p_cc_profile_used);
992: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

Line 990: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

986: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
987: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
988: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
989:
990: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
991: p_cc_profile_used);
992: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
993: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
994: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);

Line 992: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

988: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
989:
990: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
991: p_cc_profile_used);
992: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
993: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
994: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
995: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
996: OE_MSG_PUB.Add;

Line 993: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

989:
990: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
991: p_cc_profile_used);
992: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
993: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
994: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
995: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
996: OE_MSG_PUB.Add;
997: ELSIF p_cc_profile_used = 'CUSTOMER'

Line 994: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);

990: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
991: p_cc_profile_used);
992: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
993: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
994: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
995: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
996: OE_MSG_PUB.Add;
997: ELSIF p_cc_profile_used = 'CUSTOMER'
998: THEN

Line 995: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);

991: p_cc_profile_used);
992: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
993: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
994: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
995: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
996: OE_MSG_PUB.Add;
997: ELSIF p_cc_profile_used = 'CUSTOMER'
998: THEN
999: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 999: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

995: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
996: OE_MSG_PUB.Add;
997: ELSIF p_cc_profile_used = 'CUSTOMER'
998: THEN
999: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1000: p_cc_profile_used);
1001: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1002: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1003: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);

Line 1001: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);

997: ELSIF p_cc_profile_used = 'CUSTOMER'
998: THEN
999: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1000: p_cc_profile_used);
1001: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1002: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1003: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1004: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1005:

Line 1002: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);

998: THEN
999: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1000: p_cc_profile_used);
1001: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1002: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1003: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1004: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1005:
1006: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 1003: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);

999: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1000: p_cc_profile_used);
1001: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1002: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1003: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1004: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1005:
1006: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1007: p_cc_profile_used);

Line 1004: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

1000: p_cc_profile_used);
1001: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1002: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1003: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1004: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1005:
1006: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1007: p_cc_profile_used);
1008: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

Line 1006: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

1002: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1003: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1004: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1005:
1006: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1007: p_cc_profile_used);
1008: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1009: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1010: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);

Line 1008: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

1004: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1005:
1006: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1007: p_cc_profile_used);
1008: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1009: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1010: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1011: OE_MSG_PUB.Add;
1012:

Line 1009: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

1005:
1006: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1007: p_cc_profile_used);
1008: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1009: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1010: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1011: OE_MSG_PUB.Add;
1012:
1013: ELSIF p_cc_profile_used = 'PARTY'

Line 1010: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);

1006: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1007: p_cc_profile_used);
1008: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1009: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1010: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1011: OE_MSG_PUB.Add;
1012:
1013: ELSIF p_cc_profile_used = 'PARTY'
1014: THEN

Line 1015: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

1011: OE_MSG_PUB.Add;
1012:
1013: ELSIF p_cc_profile_used = 'PARTY'
1014: THEN
1015: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1016: p_cc_profile_used);
1017: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1018: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1019: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name );

Line 1017: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);

1013: ELSIF p_cc_profile_used = 'PARTY'
1014: THEN
1015: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1016: p_cc_profile_used);
1017: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1018: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1019: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name );
1020: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1021:

Line 1018: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);

1014: THEN
1015: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1016: p_cc_profile_used);
1017: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1018: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1019: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name );
1020: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1021:
1022: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 1019: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name );

1015: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1016: p_cc_profile_used);
1017: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1018: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1019: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name );
1020: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1021:
1022: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1023: p_cc_profile_used);

Line 1020: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

1016: p_cc_profile_used);
1017: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1018: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1019: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name );
1020: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1021:
1022: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1023: p_cc_profile_used);
1024: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

Line 1022: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

1018: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1019: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name );
1020: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1021:
1022: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1023: p_cc_profile_used);
1024: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1025: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1026: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name) ;

Line 1024: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

1020: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1021:
1022: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1023: p_cc_profile_used);
1024: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1025: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1026: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name) ;
1027: OE_MSG_PUB.Add;
1028:

Line 1025: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

1021:
1022: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1023: p_cc_profile_used);
1024: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1025: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1026: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name) ;
1027: OE_MSG_PUB.Add;
1028:
1029: ELSIF p_cc_profile_used = 'DEFAULT' THEN

Line 1026: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name) ;

1022: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1023: p_cc_profile_used);
1024: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1025: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1026: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name) ;
1027: OE_MSG_PUB.Add;
1028:
1029: ELSIF p_cc_profile_used = 'DEFAULT' THEN
1030: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 1030: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

1026: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name) ;
1027: OE_MSG_PUB.Add;
1028:
1029: ELSIF p_cc_profile_used = 'DEFAULT' THEN
1030: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1031: p_cc_profile_used);
1032: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1033: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1034: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

Line 1032: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

1028:
1029: ELSIF p_cc_profile_used = 'DEFAULT' THEN
1030: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1031: p_cc_profile_used);
1032: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1033: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1034: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1035:
1036: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 1033: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

1029: ELSIF p_cc_profile_used = 'DEFAULT' THEN
1030: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1031: p_cc_profile_used);
1032: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1033: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1034: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1035:
1036: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1037: p_cc_profile_used);

Line 1034: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

1030: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1031: p_cc_profile_used);
1032: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1033: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1034: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1035:
1036: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1037: p_cc_profile_used);
1038: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

Line 1036: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

1032: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1033: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1034: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1035:
1036: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1037: p_cc_profile_used);
1038: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1039: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1040: OE_MSG_PUB.Add;

Line 1038: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

1034: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1035:
1036: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1037: p_cc_profile_used);
1038: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1039: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1040: OE_MSG_PUB.Add;
1041: END IF;
1042: END IF;

Line 1039: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

1035:
1036: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1037: p_cc_profile_used);
1038: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1039: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1040: OE_MSG_PUB.Add;
1041: END IF;
1042: END IF;
1043: ELSE

Line 1044: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

1040: OE_MSG_PUB.Add;
1041: END IF;
1042: END IF;
1043: ELSE
1044: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1045: 'CATEGORY');
1046: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1047: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1048: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

Line 1046: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

1042: END IF;
1043: ELSE
1044: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1045: 'CATEGORY');
1046: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1047: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1048: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1049: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1050:

Line 1047: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

1043: ELSE
1044: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1045: 'CATEGORY');
1046: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1047: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1048: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1049: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1050:
1051: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 1048: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

1044: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1045: 'CATEGORY');
1046: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1047: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1048: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1049: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1050:
1051: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1052: 'CATEGORY');

Line 1049: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

1045: 'CATEGORY');
1046: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1047: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1048: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1049: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1050:
1051: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1052: 'CATEGORY');
1053: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

Line 1051: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

1047: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1048: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1049: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1050:
1051: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1052: 'CATEGORY');
1053: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1054: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1055: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

Line 1053: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

1049: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1050:
1051: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1052: 'CATEGORY');
1053: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1054: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1055: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1056: OE_MSG_PUB.Add;
1057: END IF;

Line 1054: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

1050:
1051: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1052: 'CATEGORY');
1053: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1054: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1055: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1056: OE_MSG_PUB.Add;
1057: END IF;
1058: --END IF; -- bug 5467793

Line 1055: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

1051: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1052: 'CATEGORY');
1053: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1054: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1055: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1056: OE_MSG_PUB.Add;
1057: END IF;
1058: --END IF; -- bug 5467793
1059: --

Line 1082: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');

1078: ELSE
1079: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
1080: END IF;
1081:
1082: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1083: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1084: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1085:
1086: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

Line 1083: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);

1079: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
1080: END IF;
1081:
1082: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1083: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1084: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1085:
1086: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1087: --ER#7479609 end

Line 1084: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);

1080: END IF;
1081:
1082: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1083: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1084: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1085:
1086: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1087: --ER#7479609 end
1088:

Line 1086: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

1082: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1083: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1084: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1085:
1086: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1087: --ER#7479609 end
1088:
1089: x_comment := NVL(OE_Credit_Engine_GRP.G_currency_error_msg,l_comment);
1090:

Line 1129: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');

1125: ||' Line Number: '||TO_CHAR(p_line_number)
1126: ||' released from credit check hold.');
1127: END IF;
1128:
1129: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');
1130: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1131: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1132: OE_MSG_PUB.Add;
1133: --- rajesh

Line 1130: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

1126: ||' released from credit check hold.');
1127: END IF;
1128:
1129: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');
1130: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1131: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1132: OE_MSG_PUB.Add;
1133: --- rajesh
1134: --OE_MSG_PUB.Save_Messages(1);

Line 1131: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

1127: END IF;
1128:
1129: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');
1130: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1131: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1132: OE_MSG_PUB.Add;
1133: --- rajesh
1134: --OE_MSG_PUB.Save_Messages(1);
1135: --

Line 1183: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');

1179:
1180: --bug 4153299
1181: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
1182:
1183: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1184: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1185: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1186: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1187: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');

Line 1184: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

1180: --bug 4153299
1181: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
1182:
1183: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1184: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1185: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1186: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1187: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1188: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

Line 1185: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);

1181: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
1182:
1183: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1184: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1185: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1186: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1187: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1188: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1189: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);

Line 1186: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

1182:
1183: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1184: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1185: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1186: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1187: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1188: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1189: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1190: OE_MSG_PUB.Add;

Line 1187: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');

1183: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1184: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1185: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1186: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1187: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1188: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1189: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1190: OE_MSG_PUB.Add;
1191: ELSE

Line 1188: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

1184: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1185: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1186: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1187: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1188: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1189: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1190: OE_MSG_PUB.Add;
1191: ELSE
1192: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||

Line 1189: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);

1185: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1186: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1187: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1188: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1189: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1190: OE_MSG_PUB.Add;
1191: ELSE
1192: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1193: p_cc_profile_used);

Line 1192: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||

1188: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1189: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1190: OE_MSG_PUB.Add;
1191: ELSE
1192: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1193: p_cc_profile_used);
1194: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1195: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1196: p_cc_profile_used);

Line 1194: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

1190: OE_MSG_PUB.Add;
1191: ELSE
1192: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1193: p_cc_profile_used);
1194: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1195: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1196: p_cc_profile_used);
1197: OE_MSG_PUB.Add;
1198: END IF;

Line 1195: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||

1191: ELSE
1192: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1193: p_cc_profile_used);
1194: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1195: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1196: p_cc_profile_used);
1197: OE_MSG_PUB.Add;
1198: END IF;
1199: ELSE

Line 1200: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');

1196: p_cc_profile_used);
1197: OE_MSG_PUB.Add;
1198: END IF;
1199: ELSE
1200: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');
1201: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1202: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1203: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1204: 'CATEGORY');

Line 1201: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

1197: OE_MSG_PUB.Add;
1198: END IF;
1199: ELSE
1200: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');
1201: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1202: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1203: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1204: 'CATEGORY');
1205: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

Line 1202: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

1198: END IF;
1199: ELSE
1200: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');
1201: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1202: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1203: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1204: 'CATEGORY');
1205: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1206: OE_MSG_PUB.Add;

Line 1203: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||

1199: ELSE
1200: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');
1201: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1202: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1203: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1204: 'CATEGORY');
1205: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1206: OE_MSG_PUB.Add;
1207: END IF;

Line 1205: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

1201: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1202: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1203: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1204: 'CATEGORY');
1205: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1206: OE_MSG_PUB.Add;
1207: END IF;
1208: --
1209: -- Write to logfile if original call was from a concurrent program

Line 1224: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');

1220: ELSE
1221: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
1222: END IF;
1223:
1224: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1225: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1226: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1227:
1228: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

Line 1225: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);

1221: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
1222: END IF;
1223:
1224: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1225: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1226: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1227:
1228: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1229: --ER#7479609 end

Line 1226: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);

1222: END IF;
1223:
1224: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1225: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1226: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1227:
1228: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1229: --ER#7479609 end
1230:

Line 1228: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

1224: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1225: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1226: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1227:
1228: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1229: --ER#7479609 end
1230:
1231: x_comment := l_comment;
1232:

Line 1266: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_REMOVED');

1262: IF p_calling_action = 'AUTO RELEASE' THEN
1263: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order '||TO_CHAR(p_order_number)
1264: ||': Credit check hold released.');
1265: ELSE
1266: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_REMOVED');
1267: OE_MSG_PUB.Add;
1268: END IF;
1269: --
1270: IF G_debug_flag = 'Y'

Line 1814: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');

1810: ELSE
1811: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
1812: END IF;
1813:
1814: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1815: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1816: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1817:
1818: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

Line 1815: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);

1811: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
1812: END IF;
1813:
1814: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1815: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1816: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1817:
1818: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1819:

Line 1816: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);

1812: END IF;
1813:
1814: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1815: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1816: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1817:
1818: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1819:
1820: --ER#7479609 end

Line 1818: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

1814: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1815: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1816: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1817:
1818: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1819:
1820: --ER#7479609 end
1821:
1822:

Line 2041: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');

2037: ELSE
2038: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
2039: END IF;
2040:
2041: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
2042: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
2043: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
2044:
2045: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

Line 2042: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);

2038: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
2039: END IF;
2040:
2041: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
2042: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
2043: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
2044:
2045: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
2046: --ER#7479609 end

Line 2043: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);

2039: END IF;
2040:
2041: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
2042: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
2043: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
2044:
2045: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
2046: --ER#7479609 end
2047:

Line 2045: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

2041: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
2042: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
2043: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
2044:
2045: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
2046: --ER#7479609 end
2047:
2048: OE_Holds_PUB.Release_Holds
2049: ( p_api_version => 1.0

Line 2218: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

2214: IF x_conversion_status.COUNT > 0
2215: THEN
2216: x_cc_result_out := 'FAIL';
2217:
2218: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2219: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2220: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2221: FND_MESSAGE.Set_Token('CONV',
2222: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));

Line 2219: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);

2215: THEN
2216: x_cc_result_out := 'FAIL';
2217:
2218: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2219: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2220: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2221: FND_MESSAGE.Set_Token('CONV',
2222: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2223: OE_Credit_Engine_GRP.G_currency_error_msg :=

Line 2220: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );

2216: x_cc_result_out := 'FAIL';
2217:
2218: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2219: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2220: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2221: FND_MESSAGE.Set_Token('CONV',
2222: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2223: OE_Credit_Engine_GRP.G_currency_error_msg :=
2224: SUBSTR(FND_MESSAGE.GET,1,1000) ;

Line 2221: FND_MESSAGE.Set_Token('CONV',

2217:
2218: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2219: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2220: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2221: FND_MESSAGE.Set_Token('CONV',
2222: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2223: OE_Credit_Engine_GRP.G_currency_error_msg :=
2224: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2225:

Line 2224: SUBSTR(FND_MESSAGE.GET,1,1000) ;

2220: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2221: FND_MESSAGE.Set_Token('CONV',
2222: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2223: OE_Credit_Engine_GRP.G_currency_error_msg :=
2224: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2225:
2226: G_result_out := 'FAIL' ;
2227: x_cc_result_out := 'FAIL' ;
2228:

Line 2231: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

2227: x_cc_result_out := 'FAIL' ;
2228:
2229: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
2230: THEN
2231: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2232: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2233: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2234: FND_MESSAGE.Set_Token('CONV',
2235: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));

Line 2232: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);

2228:
2229: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
2230: THEN
2231: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2232: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2233: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2234: FND_MESSAGE.Set_Token('CONV',
2235: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2236:

Line 2233: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );

2229: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
2230: THEN
2231: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2232: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2233: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2234: FND_MESSAGE.Set_Token('CONV',
2235: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2236:
2237: OE_MSG_PUB.ADD;

Line 2234: FND_MESSAGE.Set_Token('CONV',

2230: THEN
2231: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2232: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2233: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2234: FND_MESSAGE.Set_Token('CONV',
2235: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2236:
2237: OE_MSG_PUB.ADD;
2238: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2637: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

2633: x_cc_result_out := 'FAIL' ;
2634:
2635: OE_DEBUG_PUB.Add(' Currency conversion failed ');
2636:
2637: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2638: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2639: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2640: FND_MESSAGE.Set_Token('CONV',
2641: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));

Line 2638: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);

2634:
2635: OE_DEBUG_PUB.Add(' Currency conversion failed ');
2636:
2637: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2638: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2639: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2640: FND_MESSAGE.Set_Token('CONV',
2641: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2642: OE_Credit_Engine_GRP.G_currency_error_msg :=

Line 2639: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );

2635: OE_DEBUG_PUB.Add(' Currency conversion failed ');
2636:
2637: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2638: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2639: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2640: FND_MESSAGE.Set_Token('CONV',
2641: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2642: OE_Credit_Engine_GRP.G_currency_error_msg :=
2643: SUBSTR(FND_MESSAGE.GET,1,1000) ;

Line 2640: FND_MESSAGE.Set_Token('CONV',

2636:
2637: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2638: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2639: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2640: FND_MESSAGE.Set_Token('CONV',
2641: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2642: OE_Credit_Engine_GRP.G_currency_error_msg :=
2643: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2644:

Line 2643: SUBSTR(FND_MESSAGE.GET,1,1000) ;

2639: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2640: FND_MESSAGE.Set_Token('CONV',
2641: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2642: OE_Credit_Engine_GRP.G_currency_error_msg :=
2643: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2644:
2645: G_result_out := 'FAIL' ;
2646: x_cc_result_out := 'FAIL' ;
2647:

Line 2651: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

2647:
2648:
2649: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
2650: THEN
2651: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2652: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2653: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2654: FND_MESSAGE.Set_Token('CONV',
2655: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));

Line 2652: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);

2648:
2649: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
2650: THEN
2651: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2652: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2653: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2654: FND_MESSAGE.Set_Token('CONV',
2655: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2656:

Line 2653: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );

2649: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
2650: THEN
2651: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2652: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2653: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2654: FND_MESSAGE.Set_Token('CONV',
2655: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2656:
2657:

Line 2654: FND_MESSAGE.Set_Token('CONV',

2650: THEN
2651: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2652: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2653: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2654: FND_MESSAGE.Set_Token('CONV',
2655: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2656:
2657:
2658: OE_MSG_PUB.ADD;

Line 2881: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

2877: OE_DEBUG_PUB.Add('Apply_Order_CC_Hold for Item category');
2878: OE_DEBUG_PUB.Add('currency = '|| p_header_rec.transactional_curr_code );
2879: OE_DEBUG_PUB.Add('checking category = '|| l_check_category_id );
2880:
2881: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2882: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
2883: FND_MESSAGE.Set_Token('TO',l_limit_currency );
2884: FND_MESSAGE.Set_Token('CONV',
2885: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));

Line 2882: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );

2878: OE_DEBUG_PUB.Add('currency = '|| p_header_rec.transactional_curr_code );
2879: OE_DEBUG_PUB.Add('checking category = '|| l_check_category_id );
2880:
2881: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2882: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
2883: FND_MESSAGE.Set_Token('TO',l_limit_currency );
2884: FND_MESSAGE.Set_Token('CONV',
2885: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2886: OE_Credit_Engine_GRP.G_currency_error_msg :=

Line 2883: FND_MESSAGE.Set_Token('TO',l_limit_currency );

2879: OE_DEBUG_PUB.Add('checking category = '|| l_check_category_id );
2880:
2881: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2882: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
2883: FND_MESSAGE.Set_Token('TO',l_limit_currency );
2884: FND_MESSAGE.Set_Token('CONV',
2885: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2886: OE_Credit_Engine_GRP.G_currency_error_msg :=
2887: SUBSTR(FND_MESSAGE.GET,1,1000) ;

Line 2884: FND_MESSAGE.Set_Token('CONV',

2880:
2881: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2882: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
2883: FND_MESSAGE.Set_Token('TO',l_limit_currency );
2884: FND_MESSAGE.Set_Token('CONV',
2885: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2886: OE_Credit_Engine_GRP.G_currency_error_msg :=
2887: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2888: G_result_out := 'FAIL' ;

Line 2887: SUBSTR(FND_MESSAGE.GET,1,1000) ;

2883: FND_MESSAGE.Set_Token('TO',l_limit_currency );
2884: FND_MESSAGE.Set_Token('CONV',
2885: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2886: OE_Credit_Engine_GRP.G_currency_error_msg :=
2887: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2888: G_result_out := 'FAIL' ;
2889: x_cc_result_out := 'FAIL' ;
2890:
2891:

Line 2894: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

2890:
2891:
2892: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
2893: THEN
2894: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2895: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
2896: FND_MESSAGE.Set_Token('TO',l_limit_currency );
2897: FND_MESSAGE.Set_Token('CONV',
2898: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));

Line 2895: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );

2891:
2892: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
2893: THEN
2894: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2895: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
2896: FND_MESSAGE.Set_Token('TO',l_limit_currency );
2897: FND_MESSAGE.Set_Token('CONV',
2898: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2899:

Line 2896: FND_MESSAGE.Set_Token('TO',l_limit_currency );

2892: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
2893: THEN
2894: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2895: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
2896: FND_MESSAGE.Set_Token('TO',l_limit_currency );
2897: FND_MESSAGE.Set_Token('CONV',
2898: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2899:
2900: OE_MSG_PUB.ADD ;

Line 2897: FND_MESSAGE.Set_Token('CONV',

2893: THEN
2894: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2895: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
2896: FND_MESSAGE.Set_Token('TO',l_limit_currency );
2897: FND_MESSAGE.Set_Token('CONV',
2898: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2899:
2900: OE_MSG_PUB.ADD ;
2901: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3502: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');

3498: );
3499:
3500: IF x_return_status='S'
3501: THEN
3502: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');
3503: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);
3504: OE_MSG_PUB.Add;
3505: END IF;
3506:

Line 3503: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);

3499:
3500: IF x_return_status='S'
3501: THEN
3502: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');
3503: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);
3504: OE_MSG_PUB.Add;
3505: END IF;
3506:
3507: IF G_debug_flag = 'Y'

Line 4326: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');

4322: p_entity_code => 'HEADER'
4323: ,p_entity_id => p_header_rec.header_id
4324: ,p_header_id => p_header_rec.header_id );
4325:
4326: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');
4327: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);
4328: OE_MSG_PUB.Add;
4329: OE_MSG_PUB.Reset_Msg_Context('HEADER'); --bug 4503551
4330: END IF;

Line 4327: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);

4323: ,p_entity_id => p_header_rec.header_id
4324: ,p_header_id => p_header_rec.header_id );
4325:
4326: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');
4327: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);
4328: OE_MSG_PUB.Add;
4329: OE_MSG_PUB.Reset_Msg_Context('HEADER'); --bug 4503551
4330: END IF;
4331:

Line 4447: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_GENERAL_MSG');

4443: --FND_API.G_TRUE AND x_cc_result_out IN ('FAIL_HOLD', 'FAIL_NONE'))
4444: THEN
4445: -- Display the general message for the user on the screen
4446:
4447: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_GENERAL_MSG');
4448:
4449: OE_MSG_PUB.Add;
4450: END IF;
4451:

Line 4455: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_REMOVED');

4451:
4452: IF G_release_status = 'RELEASED'
4453: THEN
4454:
4455: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_REMOVED');
4456: OE_MSG_PUB.Add;
4457:
4458: END IF;
4459: