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.IBC_CITEM_WORKFLOW_PVT dependencies on FND_GLOBAL

Line 334: WHERE user_id = FND_GLOBAL.USER_ID;

330: 'PARTY', 'RS_PARTY' ,
331: 'OTHER','RS_OTHER',
332: 'TBH', 'RS_TBH') resource_type
333: FROM jtf_rs_resource_extns
334: WHERE user_id = FND_GLOBAL.USER_ID;
335:
336: CURSOR c_owner(p_citem_ver_id NUMBER) IS
337: SELECT owner_resource_id,
338: owner_resource_type,

Line 360: WHERE USER_ID = FND_GLOBAL.USER_ID;

356:
357: CURSOR c_submitter_name IS
358: SELECT INITCAP(user_name)
359: FROM fnd_user
360: WHERE USER_ID = FND_GLOBAL.USER_ID;
361:
362: CURSOR c_component_not_status (p_citem_ver_id IN NUMBER,
363: p_status IN VARCHAR2)
364: IS

Line 498: avalue => FND_GLOBAL.USER_NAME);

494:
495: WF_ENGINE.SetItemAttrText( itemtype => l_ItemType,
496: itemkey => l_Itemkey,
497: aname => 'SUBMITTED_BY',
498: avalue => FND_GLOBAL.USER_NAME);
499:
500: OPEN c_submitter_name;
501: FETCH c_submitter_name INTO l_submitter_name;
502: IF c_submitter_name%FOUND AND l_submitter_name IS NOT NULL THEN

Line 612: ,p_add_to_list => FND_GLOBAL.USER_NAME

608: p_resource_id => l_owner_resource_id
609: ,p_resource_type => l_owner_resource_type
610: ,px_wf_role_name => l_wf_role_name
611: ,px_wf_role_display_name => l_wf_role_display_name
612: ,p_add_to_list => FND_GLOBAL.USER_NAME
613: );
614: WF_ENGINE.SetItemAttrText( itemtype => l_ItemType,
615: itemkey => l_Itemkey,
616: aname => 'REPLY_TO',

Line 669: FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_ID',

665: avalue => p_callback_url);
666: -- Replace Info on Callback URL
667: l_format_callback_url := p_callback_url;
668: l_format_callback_url := REPLACE(l_format_callback_url,
669: FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_ID',
670: l_content_item_id);
671: l_format_callback_url := REPLACE(l_format_callback_url,
672: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_NBR',
673: l_version_number);

Line 672: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_NBR',

668: l_format_callback_url := REPLACE(l_format_callback_url,
669: FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_ID',
670: l_content_item_id);
671: l_format_callback_url := REPLACE(l_format_callback_url,
672: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_NBR',
673: l_version_number);
674: l_format_callback_url := REPLACE(l_format_callback_url,
675: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_ID',
676: p_citem_ver_id);

Line 675: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_ID',

671: l_format_callback_url := REPLACE(l_format_callback_url,
672: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_NBR',
673: l_version_number);
674: l_format_callback_url := REPLACE(l_format_callback_url,
675: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_ID',
676: p_citem_ver_id);
677: l_format_callback_url := REPLACE(l_format_callback_url,
678: FND_GLOBAL.Local_Chr(38) || 'CONTENT_TYPE_CODE',
679: getContentType(l_content_item_id));

Line 678: FND_GLOBAL.Local_Chr(38) || 'CONTENT_TYPE_CODE',

674: l_format_callback_url := REPLACE(l_format_callback_url,
675: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_ID',
676: p_citem_ver_id);
677: l_format_callback_url := REPLACE(l_format_callback_url,
678: FND_GLOBAL.Local_Chr(38) || 'CONTENT_TYPE_CODE',
679: getContentType(l_content_item_id));
680: l_format_callback_url := REPLACE(l_format_callback_url,
681: FND_GLOBAL.Local_Chr(38) || 'OBJECT_VERSION_NUMBER',
682: px_object_version_number);

Line 681: FND_GLOBAL.Local_Chr(38) || 'OBJECT_VERSION_NUMBER',

677: l_format_callback_url := REPLACE(l_format_callback_url,
678: FND_GLOBAL.Local_Chr(38) || 'CONTENT_TYPE_CODE',
679: getContentType(l_content_item_id));
680: l_format_callback_url := REPLACE(l_format_callback_url,
681: FND_GLOBAL.Local_Chr(38) || 'OBJECT_VERSION_NUMBER',
682: px_object_version_number);
683: l_format_callback_url := REPLACE(l_format_callback_url,
684: FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_LANGUAGE',
685: p_language);

Line 684: FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_LANGUAGE',

680: l_format_callback_url := REPLACE(l_format_callback_url,
681: FND_GLOBAL.Local_Chr(38) || 'OBJECT_VERSION_NUMBER',
682: px_object_version_number);
683: l_format_callback_url := REPLACE(l_format_callback_url,
684: FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_LANGUAGE',
685: p_language);
686: l_format_callback_url := REPLACE(l_format_callback_url,
687: FND_GLOBAL.Local_Chr(38) || 'ITEM_TYPE',
688: l_ItemType);

Line 687: FND_GLOBAL.Local_Chr(38) || 'ITEM_TYPE',

683: l_format_callback_url := REPLACE(l_format_callback_url,
684: FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_LANGUAGE',
685: p_language);
686: l_format_callback_url := REPLACE(l_format_callback_url,
687: FND_GLOBAL.Local_Chr(38) || 'ITEM_TYPE',
688: l_ItemType);
689: l_format_callback_url := REPLACE(l_format_callback_url,
690: FND_GLOBAL.Local_Chr(38) || 'ITEM_KEY',
691: l_ItemKey);

Line 690: FND_GLOBAL.Local_Chr(38) || 'ITEM_KEY',

686: l_format_callback_url := REPLACE(l_format_callback_url,
687: FND_GLOBAL.Local_Chr(38) || 'ITEM_TYPE',
688: l_ItemType);
689: l_format_callback_url := REPLACE(l_format_callback_url,
690: FND_GLOBAL.Local_Chr(38) || 'ITEM_KEY',
691: l_ItemKey);
692: WF_ENGINE.SetItemAttrText( itemtype => l_ItemType,
693: itemkey => l_Itemkey,
694: aname => 'ORIGINAL_CALLBACK_URL',

Line 698: FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE',

694: aname => 'ORIGINAL_CALLBACK_URL',
695: avalue => l_format_callback_url);
696:
697: l_format_callback_url := REPLACE(l_format_callback_url,
698: FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE',
699: IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL);
700:
701: WF_ENGINE.SetItemAttrText( itemtype => l_ItemType,
702: itemkey => l_Itemkey,

Line 841: avalue => get_user_description(FND_GLOBAL.user_id));

837: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
838: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
839: itemkey => itemkey,
840: aname => 'APPROVER_NAME',
841: avalue => get_user_description(FND_GLOBAL.user_id));
842: l_callback_url := WF_ENGINE.GetItemAttrText(
843: itemtype => itemtype,
844: itemkey => itemkey,
845: aname => 'ORIGINAL_CALLBACK_URL'

Line 849: FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE',

845: aname => 'ORIGINAL_CALLBACK_URL'
846: );
847: IF l_callback_url IS NOT NULL THEN
848: l_callback_url := REPLACE(l_callback_url,
849: FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE',
850: IBC_UTILITIES_PUB.G_STV_APPROVED);
851: WF_ENGINE.SetItemAttrText(
852: itemtype => itemtype,
853: itemkey => itemkey,

Line 880: l_error_msg_stack := FND_GLOBAL.Newline() || 'CITEM_VER_ID:' || l_citem_ver_id ||

876: IBC_UTILITIES_PVT.Get_Messages (
877: p_message_count => l_msg_count,
878: x_msgs => l_error_msg_stack
879: );
880: l_error_msg_stack := FND_GLOBAL.Newline() || 'CITEM_VER_ID:' || l_citem_ver_id ||
881: ' - Object Version Number:' || l_object_version_number ||
882: FND_GLOBAL.NewLine() || l_error_msg_stack;
883: WF_ENGINE.SetItemAttrText(
884: itemtype => itemtype,

Line 882: FND_GLOBAL.NewLine() || l_error_msg_stack;

878: x_msgs => l_error_msg_stack
879: );
880: l_error_msg_stack := FND_GLOBAL.Newline() || 'CITEM_VER_ID:' || l_citem_ver_id ||
881: ' - Object Version Number:' || l_object_version_number ||
882: FND_GLOBAL.NewLine() || l_error_msg_stack;
883: WF_ENGINE.SetItemAttrText(
884: itemtype => itemtype,
885: itemkey => itemkey,
886: aname => 'ERROR_MESSAGE_STACK',

Line 961: FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE',

957: );
958:
959: IF l_callback_url IS NOT NULL THEN
960: l_callback_url := REPLACE(l_callback_url,
961: FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE',
962: IBC_UTILITIES_PUB.G_STV_REJECTED);
963: WF_ENGINE.SetItemAttrText(
964: itemtype => itemtype,
965: itemkey => itemkey,

Line 999: l_error_msg_stack := FND_GLOBAL.Newline() || 'CITEM_VER_ID:' || l_citem_ver_id ||

995: IBC_UTILITIES_PVT.Get_Messages (
996: p_message_count => l_msg_count,
997: x_msgs => l_error_msg_stack
998: );
999: l_error_msg_stack := FND_GLOBAL.Newline() || 'CITEM_VER_ID:' || l_citem_ver_id ||
1000: ' - Object Version Number:' || l_object_version_number ||
1001: FND_GLOBAL.NewLine() || l_error_msg_stack;
1002: WF_ENGINE.SetItemAttrText(
1003: itemtype => itemtype,

Line 1001: FND_GLOBAL.NewLine() || l_error_msg_stack;

997: x_msgs => l_error_msg_stack
998: );
999: l_error_msg_stack := FND_GLOBAL.Newline() || 'CITEM_VER_ID:' || l_citem_ver_id ||
1000: ' - Object Version Number:' || l_object_version_number ||
1001: FND_GLOBAL.NewLine() || l_error_msg_stack;
1002: WF_ENGINE.SetItemAttrText(
1003: itemtype => itemtype,
1004: itemkey => itemkey,
1005: aname => 'ERROR_MESSAGE_STACK',

Line 1175: FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_ID',

1171: itemkey => itemkey,
1172: aname => 'UNTOUCHED_CALLBACK_URL'
1173: );
1174: l_format_callback_url := REPLACE(l_format_callback_url,
1175: FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_ID',
1176: l_content_item_id);
1177: l_format_callback_url := REPLACE(l_format_callback_url,
1178: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_NBR',
1179: l_version_number);

Line 1178: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_NBR',

1174: l_format_callback_url := REPLACE(l_format_callback_url,
1175: FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_ID',
1176: l_content_item_id);
1177: l_format_callback_url := REPLACE(l_format_callback_url,
1178: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_NBR',
1179: l_version_number);
1180: l_format_callback_url := REPLACE(l_format_callback_url,
1181: FND_GLOBAL.Local_Chr(38) || 'CONTENT_TYPE_CODE',
1182: getContentType(l_content_item_id));

Line 1181: FND_GLOBAL.Local_Chr(38) || 'CONTENT_TYPE_CODE',

1177: l_format_callback_url := REPLACE(l_format_callback_url,
1178: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_NBR',
1179: l_version_number);
1180: l_format_callback_url := REPLACE(l_format_callback_url,
1181: FND_GLOBAL.Local_Chr(38) || 'CONTENT_TYPE_CODE',
1182: getContentType(l_content_item_id));
1183: l_format_callback_url := REPLACE(l_format_callback_url,
1184: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_ID',
1185: l_citem_ver_id);

Line 1184: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_ID',

1180: l_format_callback_url := REPLACE(l_format_callback_url,
1181: FND_GLOBAL.Local_Chr(38) || 'CONTENT_TYPE_CODE',
1182: getContentType(l_content_item_id));
1183: l_format_callback_url := REPLACE(l_format_callback_url,
1184: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_ID',
1185: l_citem_ver_id);
1186: l_format_callback_url := REPLACE(l_format_callback_url,
1187: FND_GLOBAL.Local_Chr(38) || 'OBJECT_VERSION_NUMBER',
1188: IBC_CITEM_ADMIN_GRP.getobjvernum(l_content_item_id));

Line 1187: FND_GLOBAL.Local_Chr(38) || 'OBJECT_VERSION_NUMBER',

1183: l_format_callback_url := REPLACE(l_format_callback_url,
1184: FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_ID',
1185: l_citem_ver_id);
1186: l_format_callback_url := REPLACE(l_format_callback_url,
1187: FND_GLOBAL.Local_Chr(38) || 'OBJECT_VERSION_NUMBER',
1188: IBC_CITEM_ADMIN_GRP.getobjvernum(l_content_item_id));
1189: l_format_callback_url := REPLACE(l_format_callback_url,
1190: FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_LANGUAGE',
1191: l_language);

Line 1190: FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_LANGUAGE',

1186: l_format_callback_url := REPLACE(l_format_callback_url,
1187: FND_GLOBAL.Local_Chr(38) || 'OBJECT_VERSION_NUMBER',
1188: IBC_CITEM_ADMIN_GRP.getobjvernum(l_content_item_id));
1189: l_format_callback_url := REPLACE(l_format_callback_url,
1190: FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_LANGUAGE',
1191: l_language);
1192: l_format_callback_url := REPLACE(l_format_callback_url,
1193: FND_GLOBAL.Local_Chr(38) || 'ITEM_TYPE',
1194: l_ItemType);

Line 1193: FND_GLOBAL.Local_Chr(38) || 'ITEM_TYPE',

1189: l_format_callback_url := REPLACE(l_format_callback_url,
1190: FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_LANGUAGE',
1191: l_language);
1192: l_format_callback_url := REPLACE(l_format_callback_url,
1193: FND_GLOBAL.Local_Chr(38) || 'ITEM_TYPE',
1194: l_ItemType);
1195: l_format_callback_url := REPLACE(l_format_callback_url,
1196: FND_GLOBAL.Local_Chr(38) || 'ITEM_KEY',
1197: l_ItemKey);

Line 1196: FND_GLOBAL.Local_Chr(38) || 'ITEM_KEY',

1192: l_format_callback_url := REPLACE(l_format_callback_url,
1193: FND_GLOBAL.Local_Chr(38) || 'ITEM_TYPE',
1194: l_ItemType);
1195: l_format_callback_url := REPLACE(l_format_callback_url,
1196: FND_GLOBAL.Local_Chr(38) || 'ITEM_KEY',
1197: l_ItemKey);
1198: l_format_callback_url := REPLACE(l_format_callback_url,
1199: FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE',
1200: 'TRANSLATE');

Line 1199: FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE',

1195: l_format_callback_url := REPLACE(l_format_callback_url,
1196: FND_GLOBAL.Local_Chr(38) || 'ITEM_KEY',
1197: l_ItemKey);
1198: l_format_callback_url := REPLACE(l_format_callback_url,
1199: FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE',
1200: 'TRANSLATE');
1201: WF_ENGINE.SetItemAttrText( itemtype => l_ItemType,
1202: itemkey => l_Itemkey,
1203: aname => 'CALLBACK_URL',

Line 1222: FND_GLOBAL.Newline() || 'CITEM_VER_ID:' || l_citem_ver_id;

1218: ELSE
1219: -- IF l_return_status not successful then return 'N'
1220: result := 'COMPLETE:N';
1221: l_error_msg_stack := 'Error During IBC_CITEM_WORKFLOW_PVT.Process_Translations -- ' ||
1222: FND_GLOBAL.Newline() || 'CITEM_VER_ID:' || l_citem_ver_id;
1223: l_error_msg_stack := l_error_msg_stack || FND_GLOBAL.Newline() || 'Return Status: ' ||
1224: l_return_status || FND_GLOBAL.Newline() || FND_GLOBAL.Newline() ;
1225: FOR I IN 1..l_msg_count LOOP
1226: l_error_msg_stack := l_error_msg_stack || ' ... ' ||

Line 1223: l_error_msg_stack := l_error_msg_stack || FND_GLOBAL.Newline() || 'Return Status: ' ||

1219: -- IF l_return_status not successful then return 'N'
1220: result := 'COMPLETE:N';
1221: l_error_msg_stack := 'Error During IBC_CITEM_WORKFLOW_PVT.Process_Translations -- ' ||
1222: FND_GLOBAL.Newline() || 'CITEM_VER_ID:' || l_citem_ver_id;
1223: l_error_msg_stack := l_error_msg_stack || FND_GLOBAL.Newline() || 'Return Status: ' ||
1224: l_return_status || FND_GLOBAL.Newline() || FND_GLOBAL.Newline() ;
1225: FOR I IN 1..l_msg_count LOOP
1226: l_error_msg_stack := l_error_msg_stack || ' ... ' ||
1227: FND_MSG_PUB.get(p_encoded => FND_API.g_false) ||

Line 1224: l_return_status || FND_GLOBAL.Newline() || FND_GLOBAL.Newline() ;

1220: result := 'COMPLETE:N';
1221: l_error_msg_stack := 'Error During IBC_CITEM_WORKFLOW_PVT.Process_Translations -- ' ||
1222: FND_GLOBAL.Newline() || 'CITEM_VER_ID:' || l_citem_ver_id;
1223: l_error_msg_stack := l_error_msg_stack || FND_GLOBAL.Newline() || 'Return Status: ' ||
1224: l_return_status || FND_GLOBAL.Newline() || FND_GLOBAL.Newline() ;
1225: FOR I IN 1..l_msg_count LOOP
1226: l_error_msg_stack := l_error_msg_stack || ' ... ' ||
1227: FND_MSG_PUB.get(p_encoded => FND_API.g_false) ||
1228: FND_GLOBAL.Newline();

Line 1228: FND_GLOBAL.Newline();

1224: l_return_status || FND_GLOBAL.Newline() || FND_GLOBAL.Newline() ;
1225: FOR I IN 1..l_msg_count LOOP
1226: l_error_msg_stack := l_error_msg_stack || ' ... ' ||
1227: FND_MSG_PUB.get(p_encoded => FND_API.g_false) ||
1228: FND_GLOBAL.Newline();
1229: END LOOP;
1230: WF_ENGINE.SetItemAttrText(
1231: itemtype => itemtype,
1232: itemkey => itemkey,

Line 1320: avalue => get_user_description(FND_GLOBAL.user_id));

1316: IF p_response IN ('Y', 'N') THEN
1317: WF_ENGINE.SetItemAttrText( itemtype => p_item_type,
1318: itemkey => p_item_key,
1319: aname => 'APPROVER_NAME',
1320: avalue => get_user_description(FND_GLOBAL.user_id));
1321: IF p_notes_to_submitter IS NOT NULL THEN
1322: WF_ENGINE.SetItemAttrText( itemtype => p_item_type,
1323: itemkey => p_item_key,
1324: aname => 'NOTES_TO_SUBMITTER',

Line 1542: WHERE USER_NAME = FND_GLOBAL.USER_NAME;

1538: -- Submit_For_Approval proc.
1539: CURSOR c_notifications IS
1540: SELECT *
1541: FROM IBC_PENDING_APPROVALS_V
1542: WHERE USER_NAME = FND_GLOBAL.USER_NAME;
1543:
1544: --******** local variable for standards **********
1545: l_api_name CONSTANT VARCHAR2(30) := 'Get_Pending_Approvals';
1546: l_api_version CONSTANT NUMBER := 1.0;

Line 1678: WHERE USER_NAME = FND_GLOBAL.USER_NAME;

1674: -- Submit_For_Approval proc.
1675: CURSOR c_notifications IS
1676: SELECT *
1677: FROM IBC_PENDING_TRANSLATIONS_V
1678: WHERE USER_NAME = FND_GLOBAL.USER_NAME;
1679:
1680: --******** local variable for standards **********
1681: l_api_name CONSTANT VARCHAR2(30) := 'Get_Pending_Translations';
1682: l_api_version CONSTANT NUMBER := 1.0;

Line 1879: WHERE user_id = FND_GLOBAL.USER_ID;

1875: ,'PARTY', 'RS_PARTY'
1876: ,'OTHER','RS_OTHER'
1877: ,'TBH', 'RS_TBH') resource_type
1878: FROM jtf_rs_resource_extns
1879: WHERE user_id = FND_GLOBAL.USER_ID;
1880:
1881: CURSOR c_owner(p_citem_ver_id NUMBER) IS
1882: SELECT CITEM.owner_resource_id
1883: ,CITEM.owner_resource_type

Line 1905: WHERE USER_ID = FND_GLOBAL.USER_ID;

1901:
1902: CURSOR c_submitter_name IS
1903: SELECT INITCAP(user_name)
1904: FROM fnd_user
1905: WHERE USER_ID = FND_GLOBAL.USER_ID;
1906:
1907: CURSOR c_component_not_status (p_citem_ver_id IN NUMBER,
1908: p_status IN VARCHAR2)
1909: IS

Line 2108: ,avalue => FND_GLOBAL.USER_NAME

2104:
2105: WF_ENGINE.SetItemAttrText(itemtype => l_ItemType
2106: ,itemkey => l_Itemkey
2107: ,aname => 'SUBMITTED_BY'
2108: ,avalue => FND_GLOBAL.USER_NAME
2109: );
2110:
2111: OPEN c_submitter_name;
2112: FETCH c_submitter_name INTO l_submitter_name;

Line 2184: ,p_add_to_list => FND_GLOBAL.USER_NAME

2180: p_resource_id => l_owner_resource_id
2181: ,p_resource_type => l_owner_resource_type
2182: ,px_wf_role_name => l_wf_role_name
2183: ,px_wf_role_display_name => l_wf_role_display_name
2184: ,p_add_to_list => FND_GLOBAL.USER_NAME
2185: );
2186: WF_ENGINE.SetItemAttrText(itemtype => l_ItemType
2187: ,itemkey => l_Itemkey
2188: ,aname => 'REPLY_TO'

Line 2240: ,FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_ID'

2236:
2237: -- Replace Info on Callback URL
2238: l_format_callback_url := p_callback_url;
2239: l_format_callback_url := REPLACE(l_format_callback_url
2240: ,FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_ID'
2241: ,p_citem_ver_id);
2242: l_format_callback_url := REPLACE(l_format_callback_url
2243: ,FND_GLOBAL.Local_Chr(38) || 'OBJECT_VERSION_NUMBER'
2244: ,px_object_version_number);

Line 2243: ,FND_GLOBAL.Local_Chr(38) || 'OBJECT_VERSION_NUMBER'

2239: l_format_callback_url := REPLACE(l_format_callback_url
2240: ,FND_GLOBAL.Local_Chr(38) || 'CITEM_VERSION_ID'
2241: ,p_citem_ver_id);
2242: l_format_callback_url := REPLACE(l_format_callback_url
2243: ,FND_GLOBAL.Local_Chr(38) || 'OBJECT_VERSION_NUMBER'
2244: ,px_object_version_number);
2245: l_format_callback_url := REPLACE(l_format_callback_url
2246: ,FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_LANGUAGE'
2247: ,p_language);

Line 2246: ,FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_LANGUAGE'

2242: l_format_callback_url := REPLACE(l_format_callback_url
2243: ,FND_GLOBAL.Local_Chr(38) || 'OBJECT_VERSION_NUMBER'
2244: ,px_object_version_number);
2245: l_format_callback_url := REPLACE(l_format_callback_url
2246: ,FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_LANGUAGE'
2247: ,p_language);
2248: l_format_callback_url := REPLACE(l_format_callback_url
2249: ,FND_GLOBAL.Local_Chr(38) || 'ITEM_TYPE'
2250: ,l_ItemType);

Line 2249: ,FND_GLOBAL.Local_Chr(38) || 'ITEM_TYPE'

2245: l_format_callback_url := REPLACE(l_format_callback_url
2246: ,FND_GLOBAL.Local_Chr(38) || 'CONTENT_ITEM_LANGUAGE'
2247: ,p_language);
2248: l_format_callback_url := REPLACE(l_format_callback_url
2249: ,FND_GLOBAL.Local_Chr(38) || 'ITEM_TYPE'
2250: ,l_ItemType);
2251: l_format_callback_url := REPLACE(l_format_callback_url
2252: ,FND_GLOBAL.Local_Chr(38) || 'ITEM_KEY'
2253: ,l_ItemKey);

Line 2252: ,FND_GLOBAL.Local_Chr(38) || 'ITEM_KEY'

2248: l_format_callback_url := REPLACE(l_format_callback_url
2249: ,FND_GLOBAL.Local_Chr(38) || 'ITEM_TYPE'
2250: ,l_ItemType);
2251: l_format_callback_url := REPLACE(l_format_callback_url
2252: ,FND_GLOBAL.Local_Chr(38) || 'ITEM_KEY'
2253: ,l_ItemKey);
2254:
2255: WF_ENGINE.SetItemAttrText(itemtype => l_ItemType
2256: ,itemkey => l_Itemkey

Line 2261: ,FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE'

2257: ,aname => 'ORIGINAL_CALLBACK_URL'
2258: ,avalue => l_format_callback_url);
2259:
2260: l_format_callback_url := REPLACE(l_format_callback_url
2261: ,FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE'
2262: ,IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL);
2263:
2264: WF_ENGINE.SetItemAttrText(itemtype => l_ItemType
2265: ,itemkey => l_Itemkey

Line 2434: ,FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE'

2430:
2431:
2432: IF l_callback_url IS NOT NULL THEN
2433: l_callback_url := REPLACE(l_callback_url
2434: ,FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE'
2435: ,IBC_UTILITIES_PUB.G_STV_REJECTED
2436: );
2437:
2438: WF_ENGINE.SetItemAttrText(itemtype => itemtype

Line 2481: l_error_msg_stack := FND_GLOBAL.Newline()||'CITEM_VER_ID:'

2477: IBC_UTILITIES_PVT.Get_Messages(p_message_count => l_msg_count
2478: ,x_msgs => l_error_msg_stack
2479: );
2480:
2481: l_error_msg_stack := FND_GLOBAL.Newline()||'CITEM_VER_ID:'
2482: ||l_citem_ver_id
2483: ||' - Object Version Number:'
2484: ||l_object_version_number
2485: ||FND_GLOBAL.NewLine()

Line 2485: ||FND_GLOBAL.NewLine()

2481: l_error_msg_stack := FND_GLOBAL.Newline()||'CITEM_VER_ID:'
2482: ||l_citem_ver_id
2483: ||' - Object Version Number:'
2484: ||l_object_version_number
2485: ||FND_GLOBAL.NewLine()
2486: ||l_error_msg_stack;
2487:
2488: WF_ENGINE.SetItemAttrText(itemtype => itemtype
2489: ,itemkey => itemkey

Line 2566: ,avalue => get_user_description(FND_GLOBAL.user_id)

2562: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2563: WF_ENGINE.SetItemAttrText(itemtype => itemtype
2564: ,itemkey => itemkey
2565: ,aname => 'APPROVER_NAME'
2566: ,avalue => get_user_description(FND_GLOBAL.user_id)
2567: );
2568:
2569: l_callback_url := WF_ENGINE.GetItemAttrText(itemtype => itemtype
2570: ,itemkey => itemkey

Line 2576: ,FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE'

2572: );
2573:
2574: IF l_callback_url IS NOT NULL THEN
2575: l_callback_url := REPLACE(l_callback_url
2576: ,FND_GLOBAL.Local_Chr(38) || 'ACTION_MODE'
2577: ,IBC_UTILITIES_PUB.G_STV_APPROVED
2578: );
2579:
2580: WF_ENGINE.SetItemAttrText(itemtype => itemtype

Line 2616: l_error_msg_stack := FND_GLOBAL.Newline()||'CITEM_VER_ID:'

2612: IBC_UTILITIES_PVT.Get_Messages(p_message_count => l_msg_count
2613: ,x_msgs => l_error_msg_stack
2614: );
2615:
2616: l_error_msg_stack := FND_GLOBAL.Newline()||'CITEM_VER_ID:'
2617: ||l_citem_ver_id
2618: ||' - Object Version Number:'
2619: ||l_object_version_number
2620: ||FND_GLOBAL.NewLine()

Line 2620: ||FND_GLOBAL.NewLine()

2616: l_error_msg_stack := FND_GLOBAL.Newline()||'CITEM_VER_ID:'
2617: ||l_citem_ver_id
2618: ||' - Object Version Number:'
2619: ||l_object_version_number
2620: ||FND_GLOBAL.NewLine()
2621: || l_error_msg_stack;
2622:
2623: WF_ENGINE.SetItemAttrText(itemtype => itemtype
2624: ,itemkey => itemkey