APPS.CLN_SYNC_ITEM_PKG dependencies on STANDARD

Line 37: -- Standard Start of API savepoint

33: IF (l_Debug_Level <= 2) THEN
34: cln_debug_pub.Add('----- Entering SET_SAVEPOINT_SYNC_RN API ------- ',2);
35: END IF;
36:
37: -- Standard Start of API savepoint
38: SAVEPOINT CHECK_ITEM_DELETION_PUB;
39:
40: IF (l_Debug_Level <= 1) THEN
41: cln_debug_pub.Add('++++++++ SAVEPOINT SET ++++++++ ',1);

Line 203: -- Standard Start of API savepoint

199:
200: cln_debug_pub.Add('-------- ENTERING RAISE_UPDATE_EVENT --------------', 2);
201: END IF;
202:
203: -- Standard Start of API savepoint
204: SAVEPOINT CHECK_COLLABORATION_PUB;
205:
206: -- Initialize API return status to success
207: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1912: l_message_standard VARCHAR2(100);

1908: l_doc_status VARCHAR2(25);
1909: l_phase_code VARCHAR2(25);
1910: l_process_each_row_for_errors VARCHAR2(25);
1911: l_item_number VARCHAR2(100);
1912: l_message_standard VARCHAR2(100);
1913: l_concurrent_msg VARCHAR2(250);
1914: l_supplier_name VARCHAR2(250);
1915: l_return_msg_tp VARCHAR2(2000);
1916: l_return_desc_tp VARCHAR2(2000);

Line 1998: SELECT trim(message_standard)

1994: cln_debug_pub.Add('Internal Control Number is not Null', 1);
1995: END IF;
1996:
1997: BEGIN
1998: SELECT trim(message_standard)
1999: INTO l_message_standard
2000: FROM ecx_doclogs
2001: WHERE INTERNAL_CONTROL_NUMBER = l_internal_control_number;
2002: EXCEPTION

Line 1999: INTO l_message_standard

1995: END IF;
1996:
1997: BEGIN
1998: SELECT trim(message_standard)
1999: INTO l_message_standard
2000: FROM ecx_doclogs
2001: WHERE INTERNAL_CONTROL_NUMBER = l_internal_control_number;
2002: EXCEPTION
2003: WHEN NO_DATA_FOUND THEN

Line 2010: cln_debug_pub.Add('Collaboration Standard - '||l_message_standard, 1);

2006: l_return_status_tp := '99';
2007: END;
2008:
2009: IF (l_Debug_Level <= 1) THEN
2010: cln_debug_pub.Add('Collaboration Standard - '||l_message_standard, 1);
2011: END IF;
2012:
2013: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'COLLABORATION_STANDARD', l_message_standard);
2014: END IF;

Line 2013: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'COLLABORATION_STANDARD', l_message_standard);

2009: IF (l_Debug_Level <= 1) THEN
2010: cln_debug_pub.Add('Collaboration Standard - '||l_message_standard, 1);
2011: END IF;
2012:
2013: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'COLLABORATION_STANDARD', l_message_standard);
2014: END IF;
2015:
2016:
2017: -- sending out the notification incase of an error