APPS.OKL_FUNDING_WF dependencies on OKL_ACCOUNTING_UTIL

Line 853: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

849: || '';
850:
851: -- Funding Number, Funding type
852: l_message := l_message || ''
856: || ''
859: || ''
863: || '';
867:
868: -- Vendor Name, Vendor Site Code
869: l_message := l_message || ''
873: || ''
876: || ''
880: || '
907:
908:

Line 910: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

906: || '
907:

908:
909:
913:
914:

Line 920: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

916:
917: -- Vendor Name, Vendor Site Code
918:
919: l_message := l_message || '

923:
924:

Line 926: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

922: || '
923:

924:
925:
929:
930:

Line 941: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

937: l_message := l_message || '

';
938:
939: -- Currency
940: l_message := l_message || '

Line 958: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

954: -- "Funding Details" Sub Head
955: l_message := l_message || '

956:
962:
973:
977:
978:
977:
978:

Line 991: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_SUMMY',

987: -- Funding Remaining
988: l_message := l_message || '
989:

990:
994:
995:
994:
995:
1000:

Line 1007: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ',

1003: -- Due Date
1004: l_message := l_message || '
1005:

1006:
1010:
1011:
1026:
1032:
1044:
1048:
1049:
1058:
1062:
1063:
1081:
1087:
1099:
1103:
1104:
1113:
1117:
1118:
1117:
1118:
1123:

Line 1145: l_flag := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1141: END IF;
1142: END LOOP;
1143:
1144: IF l_flag = 'Passed' THEN
1145: l_flag := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1146: p_attribute_code => 'OKL_PASSED');
1147: ELSIF l_flag = 'Failed' THEN
1148: l_flag := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1149: p_attribute_code => 'OKL_FAILED');

Line 1148: l_flag := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1144: IF l_flag = 'Passed' THEN
1145: l_flag := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1146: p_attribute_code => 'OKL_PASSED');
1147: ELSIF l_flag = 'Failed' THEN
1148: l_flag := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',
1149: p_attribute_code => 'OKL_FAILED');
1150: END IF;
1151:
1152: -- Checklist Validation Result

Line 1154: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT',

1150: END IF;
1151:
1152: -- Checklist Validation Result
1153: l_message := l_message || '

'
1157: || '';
1183:
1184: -- Description

Line 1186: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1182: || '';
1183:
1184: -- Description
1185: l_message := l_message || '

';
1192:
1193: -- Function

Line 1195: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1191: || '';
1192:
1193: -- Function
1194: l_message := l_message || '

';
1201:
1202: -- Mandatory

Line 1204: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1200: || '';
1201:
1202: -- Mandatory
1203: l_message := l_message || '

';
1210:
1211: -- Results

Line 1213: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST',

1209: || '';
1210:
1211: -- Results
1212: l_message := l_message || '

';
1219:
1220:

' 853: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 854: p_attribute_code => 'OKL_FUND_NUMBER') 855: || '	' || G_AMP_SIGN || 'nbsp;	' 857: || r_funding_req.fund_number Line 860: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 856: || '	' 857: || r_funding_req.fund_number 858: || '	' 860: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 861: p_attribute_code => 'OKL_FUNDING_TYPE') 862: || '	' || G_AMP_SIGN || 'nbsp;	' 864: || r_funding_req.funding_type_name Line 870: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 866: || '
' 870: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 871: p_attribute_code => 'OKL_VENDOR_NAME') 872: || '	' || G_AMP_SIGN || 'nbsp;	' 874: || r_funding_req.vendor_name Line 877: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 873: || '	' 874: || r_funding_req.vendor_name 875: || '	' 877: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 878: p_attribute_code => 'OKL_VENDOR_SITE') 879: || '	' || G_AMP_SIGN || 'nbsp;	' 881: || r_funding_req.vendor_site_code Line 904: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 900: /* 901: -- Funding Number, Funding type 902: 903: l_message := l_message || '
' 904: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 905: p_attribute_code => 'OKL_FUND_NUMBER') 906: || '	'|| G_AMP_SIGN ||'nbsp;	' || r_funding_req.fund_number || '	'|| G_AMP_SIGN ||'nbsp;	' || r_funding_req.fund_number || '	' 910: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 911: p_attribute_code => 'OKL_FUNDING_TYPE') 912: || '	'|| G_AMP_SIGN ||'nbsp;	' || r_funding_req.funding_type_name || '
' 920: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 921: p_attribute_code => 'OKL_VENDOR_NAME') 922: || '	'|| G_AMP_SIGN ||'nbsp;	' || r_funding_req.vendor_name || '	'|| G_AMP_SIGN ||'nbsp;	' || r_funding_req.vendor_name || '	' 926: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 927: p_attribute_code => 'OKL_VENDOR_SITE') 928: || '	'|| G_AMP_SIGN ||'nbsp;	' || r_funding_req.vendor_site_code || '
'|| G_AMP_SIGN ||'nbsp;
' 941: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 942: p_attribute_code => 'OKL_CURRENCY') 943: || ' = ' 944: || r_funding_req.currency_code 945: || '
957: ' 958: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 959: p_attribute_code => 'OKL_FUNDING_DETAILS') 960: || ' 961:	Line 974: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 970: -- Funding Total 971: l_message := l_message || ' 972:
' 974: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 975: p_attribute_code => 'OKL_AMOUNT') 976: || '	'|| G_AMP_SIGN ||'nbsp;	' Line 979: || OKL_ACCOUNTING_UTIL.format_amount( 975: p_attribute_code => 'OKL_AMOUNT') 976: || '	'|| G_AMP_SIGN ||'nbsp;	' 979: || OKL_ACCOUNTING_UTIL.format_amount( 980: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(r_funding_req.id, 981: r_funding_req.funding_type_code),0), 982: r_funding_req.currency_code) 983: || '
' 991: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_SUMMY', 992: p_attribute_code => 'OKL_TOTAL_FUNDED_REMAINING') 993: || '	'|| G_AMP_SIGN ||'nbsp;	' Line 996: || OKL_ACCOUNTING_UTIL.format_amount( 992: p_attribute_code => 'OKL_TOTAL_FUNDED_REMAINING') 993: || '	'|| G_AMP_SIGN ||'nbsp;	' 996: || OKL_ACCOUNTING_UTIL.format_amount( 997: NVL(OKL_FUNDING_PVT.get_chr_canbe_funded_rem(r_funding_req.contract_id),0), 998: r_funding_req.currency_code) 999: || '	'|| G_AMP_SIGN ||'nbsp;
' 1007: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_FUNDING_REQ', 1008: p_attribute_code => 'OKL_DATE_DUE') 1009: || '	'|| G_AMP_SIGN ||'nbsp;	' Line 1028: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CONTRACT_SRCHT', 1024: -- "Contract" Sub Head 1025: l_message := l_message || '
1027: ' 1028: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CONTRACT_SRCHT', 1029: p_attribute_code => 'OKL_CONTRACT') 1030: || ' 1031:	Line 1045: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CONTRACT_SRCHT', 1041: -- Contract Number 1042: l_message := l_message || ' 1043:
' 1045: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CONTRACT_SRCHT', 1046: p_attribute_code => 'OKL_CONTRACT_NUMBER') 1047: || '	'|| G_AMP_SIGN ||'nbsp;	' Line 1059: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT', 1055: -- Customer Name 1056: l_message := l_message || ' 1057:
' 1059: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT', 1060: p_attribute_code => 'OKL_CUSTOMER_NAME') 1061: || '	'|| G_AMP_SIGN ||'nbsp;	' Line 1083: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT', 1079: -- "Credit" Sub Head 1080: l_message := l_message || '
1082: ' 1083: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT', 1084: p_attribute_code => 'OKL_CREDIT') 1085: || ' 1086:	Line 1100: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT', 1096: -- Credit line 1097: l_message := l_message || ' 1098:
' 1100: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT', 1101: p_attribute_code => 'OKL_CREDIT_NUMBER') 1102: || '	'|| G_AMP_SIGN ||'nbsp;	' Line 1114: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT', 1110: -- Credit line remaining 1111: l_message := l_message || ' 1112:
' 1114: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT', 1115: p_attribute_code => 'OKL_REMAINING') 1116: || '	'|| G_AMP_SIGN ||'nbsp;	' Line 1119: || OKL_ACCOUNTING_UTIL.format_amount( 1115: p_attribute_code => 'OKL_REMAINING') 1116: || '	'|| G_AMP_SIGN ||'nbsp;	' 1119: || OKL_ACCOUNTING_UTIL.format_amount( 1120: nvl(OKL_SEEDED_FUNCTIONS_PVT.creditline_total_remaining(r_creditline.id),0), 1121: r_creditline.currency_code) 1122: || '	'|| G_AMP_SIGN ||'nbsp;
' 1154: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CREDIT', 1155: p_attribute_code => 'OKL_CHKLIST_VAL_RESULT') 1156: || '	=	' 1158: || l_flag Line 1177: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST', 1173: 1174: -- Headers for the creditline details table. 1175: -- Checklist Item 1176: l_message := l_message || '
' 1180: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST', 1181: p_attribute_code => 'OKL_ITEM') Line 1180: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST', 1176: l_message := l_message || '
' 1180: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST', 1181: p_attribute_code => 'OKL_ITEM') 1182: || '	' 1189: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST', 1190: p_attribute_code => 'OKL_DESCRIPTION') Line 1189: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST', 1185: l_message := l_message || '	' 1189: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST', 1190: p_attribute_code => 'OKL_DESCRIPTION') 1191: || '	' 1198: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST', 1199: p_attribute_code => 'OKL_FUNCTION') Line 1198: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST', 1194: l_message := l_message || '	' 1198: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST', 1199: p_attribute_code => 'OKL_FUNCTION') 1200: || '	' 1207: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST', 1208: p_attribute_code => 'OKL_MANDATORY') Line 1207: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST', 1203: l_message := l_message || '	' 1207: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST', 1208: p_attribute_code => 'OKL_MANDATORY') 1209: || '	' 1216: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST', 1217: p_attribute_code => 'OKL_RESULTS') Line 1216: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST', 1212: l_message := l_message || '	' 1216: || Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LA_CHECKLIST', 1217: p_attribute_code => 'OKL_RESULTS') 1218: || '