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.CN_IMPORT_CLIENT_PVT dependencies on CN_MESSAGE_PKG

Line 337: cn_message_pkg.debug('Insert Data : Start Inserting Data');

333: END IF;
334: -- Initialize API return status to success
335: x_return_status := FND_API.G_RET_STS_SUCCESS;
336: -- API body
337: cn_message_pkg.debug('Insert Data : Start Inserting Data');
338:
339: l_orig_col_count := p_col_names.COUNT;
340:
341: IF l_orig_col_count < 1 THEN

Line 342: cn_message_pkg.set_error(l_api_name,'Column count < 1');

338:
339: l_orig_col_count := p_col_names.COUNT;
340:
341: IF l_orig_col_count < 1 THEN
342: cn_message_pkg.set_error(l_api_name,'Column count < 1');
343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;
345:
346: cn_message_pkg.debug('Insert Data : Start Copy Data from p_data');

Line 346: cn_message_pkg.debug('Insert Data : Start Copy Data from p_data');

342: cn_message_pkg.set_error(l_api_name,'Column count < 1');
343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;
345:
346: cn_message_pkg.debug('Insert Data : Start Copy Data from p_data');
347:
348: -- copy data from p_data into local variables l_col*_data
349: Init_All_Col_Data
350: (p_start_index => 1,

Line 397: cn_message_pkg.debug('Insert Data : Finish Copy Data from p_data');

393: p_col40_data => l_col40_data,
394: p_insert_flag => FND_API.G_TRUE,
395: p_act_col_num => l_act_col_count);
396:
397: cn_message_pkg.debug('Insert Data : Finish Copy Data from p_data');
398:
399: -- get table name
400: l_tab_name_clause := l_tab_name_clause || p_table_name;
401:

Line 443: cn_message_pkg.debug('Insert Data : Start insert into DB');

439: SELECT CN_IMP_LINES_S.NEXTVAL
440: INTO l_prim_keys(i) FROM dual;
441: END LOOP;
442:
443: cn_message_pkg.debug('Insert Data : Start insert into DB');
444:
445: -- insert into DB
446: Insert_To_DB
447: (p_prim_keys => l_prim_keys,

Line 505: cn_message_pkg.debug('Insert Data : Finish insert into DB');

501: IF x_return_status <> FND_API.g_ret_sts_success THEN
502: RAISE FND_API.G_EXC_ERROR;
503: END IF;
504:
505: cn_message_pkg.debug('Insert Data : Finish insert into DB');
506:
507: l_col_count := l_act_col_count;
508:
509: -- Still have more columns

Line 512: cn_message_pkg.debug('Insert Data : Copy more data from p_data.');

508:
509: -- Still have more columns
510: WHILE l_col_count < l_orig_col_count
511: LOOP
512: cn_message_pkg.debug('Insert Data : Copy more data from p_data.');
513:
514: Init_All_Col_Data
515: (p_start_index => l_col_count * p_row_count + 1,
516: p_col_count => l_orig_col_count - l_col_count,

Line 562: cn_message_pkg.debug('Insert Data : Update more data from p_data.');

558: p_col40_data => l_col40_data,
559: p_insert_flag => FND_API.G_FALSE,
560: p_act_col_num => l_act_col_count);
561:
562: cn_message_pkg.debug('Insert Data : Update more data from p_data.');
563:
564: Update_DB
565: (p_prim_keys => l_prim_keys,
566: p_col_count => l_act_col_count,

Line 626: cn_message_pkg.debug('Insert Data : Finish update to DB.');

622: END IF;
623:
624: l_col_count := l_col_count + l_act_col_count;
625:
626: cn_message_pkg.debug('Insert Data : Finish update to DB.');
627:
628: END LOOP;
629:
630: -- End of API body.

Line 661: cn_message_pkg.set_error(l_api_name,'Unexpected Error.');

657: );
658: WHEN OTHERS THEN
659: ROLLBACK TO Insert_Data;
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
661: cn_message_pkg.set_error(l_api_name,'Unexpected Error.');
662: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
663: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
664: END IF;
665: FND_MSG_PUB.Count_And_Get (

Line 1278: cn_message_pkg.debug('Insert TO DB : ' || p_tab_name_clause );

1274:
1275: l_col_clause := l_col_clause || p_col_names( l_col_count) || ') ';
1276: l_value_clause := l_value_clause || ':val' || l_col_count || '(i)); END;';
1277:
1278: cn_message_pkg.debug('Insert TO DB : ' || p_tab_name_clause );
1279: cn_message_pkg.debug('Insert TO DB : ' || l_col_clause);
1280: cn_message_pkg.debug('Insert TO DB : ' || l_value_clause);
1281:
1282: --

Line 1279: cn_message_pkg.debug('Insert TO DB : ' || l_col_clause);

1275: l_col_clause := l_col_clause || p_col_names( l_col_count) || ') ';
1276: l_value_clause := l_value_clause || ':val' || l_col_count || '(i)); END;';
1277:
1278: cn_message_pkg.debug('Insert TO DB : ' || p_tab_name_clause );
1279: cn_message_pkg.debug('Insert TO DB : ' || l_col_clause);
1280: cn_message_pkg.debug('Insert TO DB : ' || l_value_clause);
1281:
1282: --
1283: -- Done for all command

Line 1280: cn_message_pkg.debug('Insert TO DB : ' || l_value_clause);

1276: l_value_clause := l_value_clause || ':val' || l_col_count || '(i)); END;';
1277:
1278: cn_message_pkg.debug('Insert TO DB : ' || p_tab_name_clause );
1279: cn_message_pkg.debug('Insert TO DB : ' || l_col_clause);
1280: cn_message_pkg.debug('Insert TO DB : ' || l_value_clause);
1281:
1282: --
1283: -- Done for all command
1284: --

Line 1694: cn_message_pkg.set_error(l_api_name,'Unexpected Error.');

1690:
1691: EXCEPTION
1692: WHEN OTHERS THEN
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: cn_message_pkg.set_error(l_api_name,'Unexpected Error.');
1695: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1696: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1697: END IF;
1698: FND_MSG_PUB.Count_And_Get (

Line 1803: cn_message_pkg.debug('Update TO DB : ' || l_update_sql );

1799: || '= :val' || l_index || '(i) ';
1800:
1801: l_update_sql := l_update_sql || ' WHERE IMP_LINE_ID = :p_keys(i); END;';
1802:
1803: cn_message_pkg.debug('Update TO DB : ' || l_update_sql );
1804:
1805: --
1806: -- Done for all command
1807: --

Line 2136: cn_message_pkg.set_error(l_api_name,'Unexpected Error.');

2132:
2133: EXCEPTION
2134: WHEN OTHERS THEN
2135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2136: cn_message_pkg.set_error(l_api_name,'Unexpected Error.');
2137: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2138: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2139: END IF;
2140: FND_MSG_PUB.Count_And_Get (