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_HDR

Line 958: -- and adds the initial details corresponding to it in both the CLN_COLL_HIST_HDR

954: -- Name
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

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

1411: IF (l_Debug_Level <= 1) THEN
1412: ecx_cln_debug_pub.Add('Collaboration Id generated : '||x_coll_id,1);
1413:
1414:
1415: ecx_cln_debug_pub.Add('----- Before SQL Query : Adding Details in CLN_COLL_HIST_HDR -----',1);
1416: END IF;
1417:
1418: IF (l_doc_creation_date is null and l_xmlg_msg_id is not null) THEN -- If collaboration history already doesnt have doc creation date and user hasnt passed it then we have to get it by parsing the payload
1419: Get_document_Creation_date(l_xmlg_msg_id,l_doc_creation_date);

Line 1424: INSERT INTO CLN_COLL_HIST_HDR(

1420: END IF;
1421:
1422:
1423: --Bug 3655492 : Added nvl(l_coll_type,'UNKNOWN') for 11.5.10 performance enh, to make sure always Collaboration Type is not null
1424: INSERT INTO CLN_COLL_HIST_HDR(
1425: COLLABORATION_ID,APPLICATION_ID,APPLICATION_REFERENCE_ID,ORG_ID,RELEASE_NO,DOCUMENT_NO,
1426: DOC_REVISION_NO,PARTNER_DOCUMENT_NO,COLLABORATION_TYPE,TRADING_PARTNER,RESEND_FLAG,
1427: RESEND_COUNT,DOCUMENT_OWNER,INITIATION_DATE,DOCUMENT_CREATION_DATE,DOCUMENT_REVISION_DATE,
1428: COLLABORATION_STATUS,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,

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

1443: p_attribute6,p_attribute7,p_attribute8,p_attribute9,p_attribute10,p_attribute11,p_attribute12,p_attribute13,
1444: p_attribute14,p_attribute15, p_dattribute1,p_dattribute2,p_dattribute3,p_dattribute4,p_dattribute5 );
1445:
1446: IF (l_Debug_Level <= 1) THEN
1447: ecx_cln_debug_pub.Add('------ After SQL Query : Adding Details in CLN_COLL_HIST_HDR --------',1);
1448: END IF;
1449:
1450:
1451:

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

1450:
1451:
1452: IF SQL%FOUND THEN
1453: IF (l_Debug_Level <= 1) THEN
1454: ecx_cln_debug_pub.Add('Collaboration Details successfully entered in CLN_COLL_HIST_HDR TABLE',1);
1455: END IF;
1456:
1457: ELSE
1458: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');

Line 1459: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_HDR');

1455: END IF;
1456:
1457: ELSE
1458: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');
1459: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_HDR');
1460: x_msg_data := FND_MESSAGE.GET;
1461: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_HDR TABLE';
1462: RAISE FND_API.G_EXC_ERROR;
1463: END IF;

Line 1461: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_HDR TABLE';

1457: ELSE
1458: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');
1459: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_HDR');
1460: x_msg_data := FND_MESSAGE.GET;
1461: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_HDR TABLE';
1462: RAISE FND_API.G_EXC_ERROR;
1463: END IF;
1464:
1465: IF(l_msg_text IS NULL) THEN

Line 1556: -- table and also modifies the CLN_COLL_HIST_HDR if the need may be.

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
1560: -- No specific notes.

Line 2091: FROM CLN_COLL_HIST_HDR

2087: END IF;
2088:
2089: SELECT APPLICATION_ID, COLLABORATION_TYPE, DOCUMENT_CREATION_DATE
2090: INTO l_app_id, l_coll_type, l_doc_creation_date
2091: FROM CLN_COLL_HIST_HDR
2092: WHERE COLLABORATION_ID = l_coll_id;
2093:
2094: IF (l_Debug_Level <= 1) THEN
2095: ecx_cln_debug_pub.Add('--- After the query to find the Application ID/Collaboration Type----',1);

Line 2170: ecx_cln_debug_pub.Add('--- Before SQL Query : Updating CLN_COLL_HIST_HDR ---',1);

2166: END IF;
2167:
2168:
2169: IF (l_Debug_Level <= 1) THEN
2170: ecx_cln_debug_pub.Add('--- Before SQL Query : Updating CLN_COLL_HIST_HDR ---',1);
2171: END IF;
2172:
2173:
2174: UPDATE CLN_COLL_HIST_HDR

Line 2174: UPDATE CLN_COLL_HIST_HDR

2170: ecx_cln_debug_pub.Add('--- Before SQL Query : Updating CLN_COLL_HIST_HDR ---',1);
2171: END IF;
2172:
2173:
2174: UPDATE CLN_COLL_HIST_HDR
2175: SET APPLICATION_ID = NVL(l_app_id,APPLICATION_ID),
2176: APPLICATION_REFERENCE_ID = NVL(l_ref_id,APPLICATION_REFERENCE_ID),
2177: RELEASE_NO = NVL(p_rel_no,RELEASE_NO),
2178: DOC_REVISION_NO = NVL(p_doc_rev_no,DOC_REVISION_NO),

Line 2237: ecx_cln_debug_pub.Add('--- After SQL Query : Updating CLN_COLL_HIST_HDR ---',1);

2233: then the value obtained by us from xml gateway tables needs to be filled in
2234: ===========================================================================*/
2235:
2236: IF (l_Debug_Level <= 1) THEN
2237: ecx_cln_debug_pub.Add('--- After SQL Query : Updating CLN_COLL_HIST_HDR ---',1);
2238: END IF;
2239:
2240:
2241:

Line 2244: ecx_cln_debug_pub.Add('Collaboration Details successfully updated in CLN_COLL_HIST_HDR TABLE',1);

2240:
2241:
2242: IF SQL%FOUND THEN
2243: IF (l_Debug_Level <= 1) THEN
2244: ecx_cln_debug_pub.Add('Collaboration Details successfully updated in CLN_COLL_HIST_HDR TABLE',1);
2245: END IF;
2246:
2247: ELSE
2248: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_FOUND');

Line 2453: SELECT COLLABORATION_STATUS INTO x_coll_status FROM CLN_COLL_HIST_HDR

2449: ecx_cln_debug_pub.Add('--- Before SQL Query : Retrieving Collaboration Status ---',1);
2450: END IF;
2451:
2452:
2453: SELECT COLLABORATION_STATUS INTO x_coll_status FROM CLN_COLL_HIST_HDR
2454: WHERE (COLLABORATION_ID = p_coll_id)
2455: OR (APPLICATION_REFERENCE_ID = p_ref_id)
2456: OR (APPLICATION_ID = p_app_id
2457: AND UNIQUE_ID1 = p_unique1)

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 3496: ecx_cln_debug_pub.Add('Before SQL Query 1 : Retrieving Collaboration ID using CLN_COLL_HIST_HDR',1);

3492: END IF;
3493:
3494: IF (p_coll_id is NULL) THEN
3495: IF (l_Debug_Level <= 1) THEN
3496: ecx_cln_debug_pub.Add('Before SQL Query 1 : Retrieving Collaboration ID using CLN_COLL_HIST_HDR',1);
3497: END IF;
3498:
3499: BEGIN
3500: SELECT COLLABORATION_ID INTO l_coll_id

Line 3501: FROM CLN_COLL_HIST_HDR

3497: END IF;
3498:
3499: BEGIN
3500: SELECT COLLABORATION_ID INTO l_coll_id
3501: FROM CLN_COLL_HIST_HDR
3502: WHERE APPLICATION_REFERENCE_ID = p_ref_id
3503: OR XMLG_MSG_ID = p_xmlg_msg_id
3504: OR XMLG_INTERNAL_CONTROL_NUMBER = p_xmlg_internal_control_number;
3505: EXCEPTION

Line 3520: ecx_cln_debug_pub.Add('Before SQL Query 2 : Retrieving Collaboration ID using CLN_COLL_HIST_HDR',1);

3516: p_unique4 IS NOT NULL OR
3517: p_unique5 IS NOT NULL THEN
3518:
3519: IF (l_Debug_Level <= 1) THEN
3520: ecx_cln_debug_pub.Add('Before SQL Query 2 : Retrieving Collaboration ID using CLN_COLL_HIST_HDR',1);
3521: END IF;
3522:
3523: BEGIN
3524: SELECT COLLABORATION_ID INTO l_coll_id

Line 3525: FROM CLN_COLL_HIST_HDR

3521: END IF;
3522:
3523: BEGIN
3524: SELECT COLLABORATION_ID INTO l_coll_id
3525: FROM CLN_COLL_HIST_HDR
3526: WHERE (APPLICATION_ID = p_app_id AND UNIQUE_ID1 = p_unique1)
3527: OR (APPLICATION_ID = p_app_id AND UNIQUE_ID2 = p_unique2)
3528: OR (APPLICATION_ID = p_app_id AND UNIQUE_ID3 = p_unique3)
3529: OR (APPLICATION_ID = p_app_id AND UNIQUE_ID4 = p_unique4)

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 4494: ecx_cln_debug_pub.Add('----- Query 1: Finding Collaboration ID from CLN_COLL_HIST_HDR table ----',1);

4490:
4491:
4492: BEGIN
4493: IF (l_Debug_Level <= 1) THEN
4494: ecx_cln_debug_pub.Add('----- Query 1: Finding Collaboration ID from CLN_COLL_HIST_HDR table ----',1);
4495: END IF;
4496:
4497: SELECT COLLABORATION_ID INTO x_coll_id
4498: FROM CLN_COLL_HIST_HDR

Line 4498: FROM CLN_COLL_HIST_HDR

4494: ecx_cln_debug_pub.Add('----- Query 1: Finding Collaboration ID from CLN_COLL_HIST_HDR table ----',1);
4495: END IF;
4496:
4497: SELECT COLLABORATION_ID INTO x_coll_id
4498: FROM CLN_COLL_HIST_HDR
4499: WHERE (APPLICATION_REFERENCE_ID=p_ref_id)
4500: OR XMLG_MSG_ID = p_xmlg_msg_id
4501: OR XMLG_INTERNAL_CONTROL_NUMBER = p_xmlg_internal_control_number;
4502:

Line 4525: ecx_cln_debug_pub.Add('----- Query 2: Finding Collaboration ID from CLN_COLL_HIST_HDR table ----',1);

4521: p_unique4 IS NOT NULL OR
4522: p_unique5 IS NOT NULL THEN
4523: BEGIN
4524: IF (l_Debug_Level <= 1) THEN
4525: ecx_cln_debug_pub.Add('----- Query 2: Finding Collaboration ID from CLN_COLL_HIST_HDR table ----',1);
4526: END IF;
4527:
4528: SELECT COLLABORATION_ID INTO x_coll_id
4529: FROM CLN_COLL_HIST_HDR

Line 4529: FROM CLN_COLL_HIST_HDR

4525: ecx_cln_debug_pub.Add('----- Query 2: Finding Collaboration ID from CLN_COLL_HIST_HDR table ----',1);
4526: END IF;
4527:
4528: SELECT COLLABORATION_ID INTO x_coll_id
4529: FROM CLN_COLL_HIST_HDR
4530: WHERE (APPLICATION_ID = p_app_id AND UNIQUE_ID1 = p_unique1)
4531: OR (APPLICATION_ID = p_app_id AND UNIQUE_ID2 = p_unique2)
4532: OR (APPLICATION_ID = p_app_id AND UNIQUE_ID3 = p_unique3)
4533: OR (APPLICATION_ID = p_app_id AND UNIQUE_ID4 = p_unique4)

Line 4605: ecx_cln_debug_pub.Add('----- Finding Collaboration ID from CLN_COLL_HIST_HDR table using Transaction Type/SubType',1);

4601: RETURN;
4602: END IF;
4603:
4604: IF (l_Debug_Level <= 1) THEN
4605: ecx_cln_debug_pub.Add('----- Finding Collaboration ID from CLN_COLL_HIST_HDR table using Transaction Type/SubType',1);
4606: END IF;
4607:
4608: BEGIN
4609: SELECT COLLABORATION_ID INTO x_coll_id

Line 4610: FROM CLN_COLL_HIST_HDR

4606: END IF;
4607:
4608: BEGIN
4609: SELECT COLLABORATION_ID INTO x_coll_id
4610: FROM CLN_COLL_HIST_HDR
4611: WHERE XMLG_TRANSACTION_TYPE = p_xmlg_transaction_type
4612: AND XMLG_TRANSACTION_SUBTYPE = p_xmlg_transaction_subtype
4613: AND XMLG_DOCUMENT_ID = p_xmlg_document_id
4614: AND DOCUMENT_DIRECTION = nvl(p_doc_dir, DOCUMENT_DIRECTION)