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.CLN_CH_COLLABORATION_PKG dependencies on CLN_COLL_HIST_DTL

Line 808: -- to add the initial details in the CLN_COLL_HIST_DTL table corresponding to newly started

804: -- Name
805: -- UPDATE_COLLABORATION_INIT
806: -- Purpose
807: -- This procedure is called internally by the public procedure CREATE_COLLABORATION
808: -- to add the initial details in the CLN_COLL_HIST_DTL table corresponding to newly started
809: -- collaboration.
810: -- Arguments
811: --
812: -- Notes

Line 882: ecx_cln_debug_pub.Add('----- Before SQL Query : Adding Details in CLN_COLL_HIST_DTL -----',1);

878: IF (l_Debug_Level <= 1) THEN
879: ecx_cln_debug_pub.Add('Collaboration Detail ID generated : '||l_dtl_coll_id,1);
880:
881:
882: ecx_cln_debug_pub.Add('----- Before SQL Query : Adding Details in CLN_COLL_HIST_DTL -----',1);
883: END IF;
884:
885: -- Initial Collaboration Details are added into CLN_COLL_HIST_DTL Table
886: --Bug 3655492 : Added nvl(p_doc_type,'UNKNOWN') for 11.5.10 performance enh, to make sure always Doc Type is not null

Line 885: -- Initial Collaboration Details are added into CLN_COLL_HIST_DTL Table

881:
882: ecx_cln_debug_pub.Add('----- Before SQL Query : Adding Details in CLN_COLL_HIST_DTL -----',1);
883: END IF;
884:
885: -- Initial Collaboration Details are added into CLN_COLL_HIST_DTL Table
886: --Bug 3655492 : Added nvl(p_doc_type,'UNKNOWN') for 11.5.10 performance enh, to make sure always Doc Type is not null
887: INSERT INTO CLN_COLL_HIST_DTL(
888: COLLABORATION_DTL_ID,COLLABORATION_ID,COLLABORATION_DOCUMENT_TYPE,
889: DOCUMENT_DIRECTION,COLLABORATION_POINT,

Line 887: INSERT INTO CLN_COLL_HIST_DTL(

883: END IF;
884:
885: -- Initial Collaboration Details are added into CLN_COLL_HIST_DTL Table
886: --Bug 3655492 : Added nvl(p_doc_type,'UNKNOWN') for 11.5.10 performance enh, to make sure always Doc Type is not null
887: INSERT INTO CLN_COLL_HIST_DTL(
888: COLLABORATION_DTL_ID,COLLABORATION_ID,COLLABORATION_DOCUMENT_TYPE,
889: DOCUMENT_DIRECTION,COLLABORATION_POINT,
890: ORIGINATOR_REFERENCE,DOCUMENT_STATUS,NOTIFICATION_ID,MESSAGE_TEXT,CREATION_DATE,CREATED_BY,
891: LAST_UPDATE_DATE,LAST_UPDATED_BY, LAST_UPDATE_LOGIN, XMLG_TRANSACTION_TYPE, XMLG_TRANSACTION_SUBTYPE,

Line 901: ecx_cln_debug_pub.Add('----- After SQL Query : Adding Details in CLN_COLL_HIST_DTL -----',1);

897: p_xmlg_transaction_subtype,p_xmlg_document_id, p_xmlg_msg_id, p_xmlg_internal_control_number,
898: p_resend_flag, p_xmlg_int_transaction_type, p_xmlg_int_transaction_subtype, p_xml_event_key);
899:
900: IF (l_Debug_Level <= 1) THEN
901: ecx_cln_debug_pub.Add('----- After SQL Query : Adding Details in CLN_COLL_HIST_DTL -----',1);
902: END IF;
903:
904:
905: -- Check whether the above SQL Query resulted in some updations or not.

Line 908: ecx_cln_debug_pub.Add('Collaboration Details successfully entered in CLN_COLL_HIST_DTL TABLE',1);

904:
905: -- Check whether the above SQL Query resulted in some updations or not.
906: IF SQL%FOUND THEN
907: IF (l_Debug_Level <= 1) THEN
908: ecx_cln_debug_pub.Add('Collaboration Details successfully entered in CLN_COLL_HIST_DTL TABLE',1);
909: END IF;
910: ELSE
911: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_DTL TABLE';
912: RAISE FND_API.G_EXC_ERROR;

Line 911: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_DTL TABLE';

907: IF (l_Debug_Level <= 1) THEN
908: ecx_cln_debug_pub.Add('Collaboration Details successfully entered in CLN_COLL_HIST_DTL TABLE',1);
909: END IF;
910: ELSE
911: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_DTL TABLE';
912: RAISE FND_API.G_EXC_ERROR;
913: END IF;
914:
915: IF (l_Debug_Level <= 2) THEN

Line 959: -- and CLN_COLL_HIST_DTL Tables.

955: -- CREATE_COLLABORATION
956: -- Purpose
957: -- This is the public procedure which starts a new Collaboration
958: -- and adds the initial details corresponding to it in both the CLN_COLL_HIST_HDR
959: -- and CLN_COLL_HIST_DTL Tables.
960: -- Arguments
961: --
962: -- Notes
963: -- No specific notes.

Line 1486: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_DTL');

1482:
1483:
1484: IF x_return_status <> 'S' THEN
1485: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');
1486: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_DTL');
1487: x_msg_data := FND_MESSAGE.GET;
1488: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_DTL TABLE';
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;

Line 1488: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_DTL TABLE';

1484: IF x_return_status <> 'S' THEN
1485: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');
1486: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_DTL');
1487: x_msg_data := FND_MESSAGE.GET;
1488: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_DTL TABLE';
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;
1491:
1492: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_CREATED');

Line 1555: -- to update collaboration with the progress.It creates a new row in the CLN_COLL_HIST_DTL

1551: -- Name
1552: -- UPDATE_COLLABORATION
1553: -- Purpose
1554: -- This is the public procedure which is called at subsequent stages after creation,
1555: -- to update collaboration with the progress.It creates a new row in the CLN_COLL_HIST_DTL
1556: -- table and also modifies the CLN_COLL_HIST_HDR if the need may be.
1557: -- Arguments
1558: --
1559: -- Notes

Line 2264: ecx_cln_debug_pub.Add('---- Before SQL Query : Adding Details in CLN_COLL_HIST_DTL ----',1);

2260:
2261: x_dtl_coll_id := l_dtl_coll_id;
2262:
2263: IF (l_Debug_Level <= 1) THEN
2264: ecx_cln_debug_pub.Add('---- Before SQL Query : Adding Details in CLN_COLL_HIST_DTL ----',1);
2265: END IF;
2266:
2267: --Bug 3655492 : Added nvl(l_doc_type,'UNKNOWN') for 11.5.10 performance enh, to make sure always Doc Type is not null
2268: INSERT INTO CLN_COLL_HIST_DTL(

Line 2268: INSERT INTO CLN_COLL_HIST_DTL(

2264: ecx_cln_debug_pub.Add('---- Before SQL Query : Adding Details in CLN_COLL_HIST_DTL ----',1);
2265: END IF;
2266:
2267: --Bug 3655492 : Added nvl(l_doc_type,'UNKNOWN') for 11.5.10 performance enh, to make sure always Doc Type is not null
2268: INSERT INTO CLN_COLL_HIST_DTL(
2269: COLLABORATION_DTL_ID, COLLABORATION_ID,
2270: COLLABORATION_DOCUMENT_TYPE, DOCUMENT_DIRECTION, COLLABORATION_POINT,
2271: ORIGINATOR_REFERENCE, DOCUMENT_STATUS, NOTIFICATION_ID, MESSAGE_TEXT,
2272: BSR_VERB, BSR_NOUN, BSR_REVISION,SENDER_LOGICAL_ID,SENDER_COMPONENT,

Line 2293: ecx_cln_debug_pub.Add('----- After SQL Query : Adding Details in CLN_COLL_HIST_DTL -----',1);

2289: l_xmlg_transaction_subtype, l_xmlg_document_id, l_xmlg_msg_id, l_xmlg_internal_control_number,
2290: l_resend_flag, l_xmlg_int_transaction_type, l_xmlg_int_transaction_subtype, l_xml_event_key);
2291:
2292: IF (l_Debug_Level <= 1) THEN
2293: ecx_cln_debug_pub.Add('----- After SQL Query : Adding Details in CLN_COLL_HIST_DTL -----',1);
2294: END IF;
2295:
2296:
2297: IF SQL%FOUND THEN

Line 2299: ecx_cln_debug_pub.Add('Collaboration Details successfully entered in CLN_COLL_HIST_DTL TABLE',1);

2295:
2296:
2297: IF SQL%FOUND THEN
2298: IF (l_Debug_Level <= 1) THEN
2299: ecx_cln_debug_pub.Add('Collaboration Details successfully entered in CLN_COLL_HIST_DTL TABLE',1);
2300: END IF;
2301:
2302: ELSE
2303: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');

Line 2304: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_DTL');

2300: END IF;
2301:
2302: ELSE
2303: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');
2304: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_DTL');
2305: x_msg_data := FND_MESSAGE.GET;
2306: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_DTL TABLE';
2307: RAISE FND_API.G_EXC_ERROR;
2308: END IF;

Line 2306: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_DTL TABLE';

2302: ELSE
2303: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');
2304: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_DTL');
2305: x_msg_data := FND_MESSAGE.GET;
2306: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_DTL TABLE';
2307: RAISE FND_API.G_EXC_ERROR;
2308: END IF;
2309:
2310:

Line 2508: ecx_cln_debug_pub.Add('----- Finding Collaboration status using CLN_COLL_HIST_DTL table ----',1);

2504:
2505: WHEN NO_DATA_FOUND THEN
2506: IF (l_Debug_Level <= 5) THEN
2507: ecx_cln_debug_pub.Add('Unable to find the collaboration status in Collaboration History - Header Table',1);
2508: ecx_cln_debug_pub.Add('----- Finding Collaboration status using CLN_COLL_HIST_DTL table ----',1);
2509: END IF;
2510:
2511: BEGIN
2512: SELECT COLLABORATION_STATUS INTO x_coll_status

Line 2513: FROM CLN_COLL_HIST_HDR hdr, CLN_COLL_HIST_DTL dtl

2509: END IF;
2510:
2511: BEGIN
2512: SELECT COLLABORATION_STATUS INTO x_coll_status
2513: FROM CLN_COLL_HIST_HDR hdr, CLN_COLL_HIST_DTL dtl
2514: WHERE hdr.COLLABORATION_ID = dtl.COLLABORATION_ID
2515: AND ( dtl.XMLG_MSG_ID = p_xmlg_msg_id
2516: OR dtl.XMLG_INTERNAL_CONTROL_NUMBER = p_xmlg_internal_control_number
2517: )

Line 2726: FROM CLN_COLL_HIST_HDR hdr,CLN_COLL_HIST_DTL dtl

2722: x_sdr_authid,x_sdr_datetime_qualifier,x_sdr_datetime,x_sdr_timezone,x_attr1,x_attr2,x_attr3,
2723: x_attr4,x_attr5,x_attr6,x_attr7,x_attr8,x_attr9,x_attr10,
2724: x_attr11,x_attr12,x_attr13,x_attr14,x_attr15,
2725: p_xmlg_transaction_type, p_xmlg_transaction_subtype, p_xmlg_document_id, p_xmlg_internal_control_number
2726: FROM CLN_COLL_HIST_HDR hdr,CLN_COLL_HIST_DTL dtl
2727: WHERE hdr.COLLABORATION_ID = dtl.COLLABORATION_ID
2728: AND ( dtl.COLLABORATION_DTL_ID = p_dtl_coll_id
2729: OR (
2730: ((hdr.COLLABORATION_ID = p_coll_id)

Line 2995: FROM cln_coll_hist_dtl

2991: END IF;
2992: ELSE
2993: SELECT collaboration_dtl_id
2994: INTO l_coll_dtl_id
2995: FROM cln_coll_hist_dtl
2996: WHERE collaboration_dtl_id = p_dtl_coll_id;
2997: END IF;
2998: EXCEPTION
2999: WHEN NO_DATA_FOUND THEN

Line 3414: ecx_cln_debug_pub.Add('--Before the query to CLN_COLL_HIST_DTL table ---',1);

3410:
3411:
3412: BEGIN
3413: IF (l_Debug_Level <= 1) THEN
3414: ecx_cln_debug_pub.Add('--Before the query to CLN_COLL_HIST_DTL table ---',1);
3415: END IF;
3416:
3417: SELECT MAX(collaboration_dtl_id) INTO x_dtl_coll_id
3418: FROM CLN_COLL_HIST_DTL

Line 3418: FROM CLN_COLL_HIST_DTL

3414: ecx_cln_debug_pub.Add('--Before the query to CLN_COLL_HIST_DTL table ---',1);
3415: END IF;
3416:
3417: SELECT MAX(collaboration_dtl_id) INTO x_dtl_coll_id
3418: FROM CLN_COLL_HIST_DTL
3419: WHERE COLLABORATION_POINT = nvl(p_coll_point,'APPS')
3420: AND ( XMLG_MSG_ID = p_xmlg_msg_id
3421: OR XMLG_INTERNAL_CONTROL_NUMBER = p_xmlg_internal_control_number
3422: );

Line 3424: ecx_cln_debug_pub.Add('-- After the query to CLN_COLL_HIST_DTL table ---',1);

3420: AND ( XMLG_MSG_ID = p_xmlg_msg_id
3421: OR XMLG_INTERNAL_CONTROL_NUMBER = p_xmlg_internal_control_number
3422: );
3423: IF (l_Debug_Level <= 1) THEN
3424: ecx_cln_debug_pub.Add('-- After the query to CLN_COLL_HIST_DTL table ---',1);
3425: ecx_cln_debug_pub.Add('Collaboration Detail ID : '||x_dtl_coll_id,1);
3426: END IF;
3427:
3428:

Line 3445: FROM CLN_COLL_HIST_DTL

3441:
3442:
3443: BEGIN
3444: SELECT MAX(collaboration_dtl_id) INTO x_dtl_coll_id
3445: FROM CLN_COLL_HIST_DTL
3446: WHERE COLLABORATION_POINT = nvl(p_coll_point,'APPS')
3447: AND ( (XMLG_TRANSACTION_TYPE = p_xmlg_transaction_type
3448: AND XMLG_TRANSACTION_SUBTYPE = p_xmlg_transaction_subtype
3449: AND XMLG_DOCUMENT_ID = p_xmlg_document_id

Line 3571: FROM CLN_COLL_HIST_DTL

3567: ecx_cln_debug_pub.Add('--- Before SQL Query : Retrieving Collaboration Detail ID ----',1);
3568: END IF;
3569:
3570: SELECT max(COLLABORATION_DTL_ID) INTO x_dtl_coll_id
3571: FROM CLN_COLL_HIST_DTL
3572: WHERE COLLABORATION_ID = l_coll_id
3573: AND COLLABORATION_DOCUMENT_TYPE = p_doc_type
3574: AND DOCUMENT_DIRECTION = p_doc_direction
3575: AND COLLABORATION_POINT = p_coll_point;

Line 4349: FROM CLN_COLL_HIST_HDR hdr, CLN_COLL_HIST_DTL dtl

4345:
4346:
4347: SELECT count('x')
4348: INTO l_msg_count_in_hist
4349: FROM CLN_COLL_HIST_HDR hdr, CLN_COLL_HIST_DTL dtl
4350: WHERE hdr.collaboration_id = p_coll_id
4351: AND hdr.collaboration_id = dtl.collaboration_id
4352: AND hdr.application_id = p_app_id
4353: AND hdr.collaboration_type = p_coll_type

Line 4570: ecx_cln_debug_pub.Add('----- Finding Collaboration ID from CLN_COLL_HIST_DTL table ----',1);

4566: END IF;
4567:
4568:
4569: IF (l_Debug_Level <= 1) THEN
4570: ecx_cln_debug_pub.Add('----- Finding Collaboration ID from CLN_COLL_HIST_DTL table ----',1);
4571: END IF;
4572:
4573: BEGIN
4574: SELECT COLLABORATION_ID INTO x_coll_id

Line 4575: FROM CLN_COLL_HIST_DTL

4571: END IF;
4572:
4573: BEGIN
4574: SELECT COLLABORATION_ID INTO x_coll_id
4575: FROM CLN_COLL_HIST_DTL
4576: WHERE (XMLG_MSG_ID = p_xmlg_msg_id
4577: OR XMLG_INTERNAL_CONTROL_NUMBER = p_xmlg_internal_control_number)
4578: AND ROWNUM < 2;
4579: IF (l_Debug_Level <= 1) THEN

Line 4691: FROM cln_coll_hist_dtl

4687: END IF;
4688:
4689:
4690: SELECT distinct COLLABORATION_ID INTO x_coll_id
4691: FROM cln_coll_hist_dtl
4692: WHERE XMLG_INTERNAL_CONTROL_NUMBER = l_corrspnd_internal_cntrl_num;
4693:
4694: EXCEPTION
4695: WHEN NO_DATA_FOUND THEN