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.CSI_ML_INTERFACE_TXN_PVT dependencies on FND_API

Line 36: AND ( (a.inventory_revision IS NULL AND c.inventory_revision IS NULL) OR (a.inventory_revision IS NULL AND c.inventory_revision = FND_API.G_MISS_CHAR) OR (a.inventory_revision = c.inventory_revision))

32: AND a.inventory_item_id = c.inventory_item_id
33: AND c.inst_interface_id = d.inst_interface_id
34: AND c.inst_interface_id = p_interface_id
35: AND a.instance_usage_code NOT IN ('IN_RELATIONSHIP','RETURNED')
36: AND ( (a.inventory_revision IS NULL AND c.inventory_revision IS NULL) OR (a.inventory_revision IS NULL AND c.inventory_revision = FND_API.G_MISS_CHAR) OR (a.inventory_revision = c.inventory_revision))
37: AND ( (a.lot_number IS NULL AND c.lot_number IS NULL) OR (a.lot_number IS NULL AND c.lot_number = FND_API.G_MISS_CHAR) OR (a.lot_number = c.lot_number))
38: AND a.inv_organization_id = c.inv_organization_id
39: AND a.inv_subinventory_name = c.inv_subinventory_name
40: AND ( (a.inv_locator_id IS NULL AND c.inv_locator_id IS NULL) OR (a.inv_locator_id IS NULL AND c.inv_locator_id = FND_API.G_MISS_NUM) OR (a.inv_locator_id = c.inv_locator_id))

Line 37: AND ( (a.lot_number IS NULL AND c.lot_number IS NULL) OR (a.lot_number IS NULL AND c.lot_number = FND_API.G_MISS_CHAR) OR (a.lot_number = c.lot_number))

33: AND c.inst_interface_id = d.inst_interface_id
34: AND c.inst_interface_id = p_interface_id
35: AND a.instance_usage_code NOT IN ('IN_RELATIONSHIP','RETURNED')
36: AND ( (a.inventory_revision IS NULL AND c.inventory_revision IS NULL) OR (a.inventory_revision IS NULL AND c.inventory_revision = FND_API.G_MISS_CHAR) OR (a.inventory_revision = c.inventory_revision))
37: AND ( (a.lot_number IS NULL AND c.lot_number IS NULL) OR (a.lot_number IS NULL AND c.lot_number = FND_API.G_MISS_CHAR) OR (a.lot_number = c.lot_number))
38: AND a.inv_organization_id = c.inv_organization_id
39: AND a.inv_subinventory_name = c.inv_subinventory_name
40: AND ( (a.inv_locator_id IS NULL AND c.inv_locator_id IS NULL) OR (a.inv_locator_id IS NULL AND c.inv_locator_id = FND_API.G_MISS_NUM) OR (a.inv_locator_id = c.inv_locator_id))
41: AND b.party_id = d.party_id

Line 40: AND ( (a.inv_locator_id IS NULL AND c.inv_locator_id IS NULL) OR (a.inv_locator_id IS NULL AND c.inv_locator_id = FND_API.G_MISS_NUM) OR (a.inv_locator_id = c.inv_locator_id))

36: AND ( (a.inventory_revision IS NULL AND c.inventory_revision IS NULL) OR (a.inventory_revision IS NULL AND c.inventory_revision = FND_API.G_MISS_CHAR) OR (a.inventory_revision = c.inventory_revision))
37: AND ( (a.lot_number IS NULL AND c.lot_number IS NULL) OR (a.lot_number IS NULL AND c.lot_number = FND_API.G_MISS_CHAR) OR (a.lot_number = c.lot_number))
38: AND a.inv_organization_id = c.inv_organization_id
39: AND a.inv_subinventory_name = c.inv_subinventory_name
40: AND ( (a.inv_locator_id IS NULL AND c.inv_locator_id IS NULL) OR (a.inv_locator_id IS NULL AND c.inv_locator_id = FND_API.G_MISS_NUM) OR (a.inv_locator_id = c.inv_locator_id))
41: AND b.party_id = d.party_id
42: AND b.party_source_table = d.party_source_table
43: AND b.relationship_type_code = 'OWNER';
44:

Line 54: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;

50: and msi.organization_id = cii.inv_organization_id
51: and cii.inst_interface_id = p_interface_id;
52:
53: BEGIN
54: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
55: x_return_status := 'E'; --fnd_api.g_ret_sts_success;
56: x_error_message := NULL;
57: OPEN instance_id_cur(p_inst_interface_id);
58: FETCH instance_id_cur INTO l_instance_id;

Line 55: x_return_status := 'E'; --fnd_api.g_ret_sts_success;

51: and cii.inst_interface_id = p_interface_id;
52:
53: BEGIN
54: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
55: x_return_status := 'E'; --fnd_api.g_ret_sts_success;
56: x_error_message := NULL;
57: OPEN instance_id_cur(p_inst_interface_id);
58: FETCH instance_id_cur INTO l_instance_id;
59: CLOSE instance_id_cur;

Line 68: x_return_status := fnd_api.g_ret_sts_success;

64: x_instance_id := l_instance_id;
65: EXCEPTION
66: WHEN e_exists THEN
67: x_instance_id := l_instance_id;
68: x_return_status := fnd_api.g_ret_sts_success;
69: WHEN others THEN
70: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
71: fnd_message.set_token('API_NAME','CSI_ML_INTERFACE_TXNS_PVT.INSTANCE_EXISTS');
72: fnd_message.set_token('SQL_ERROR',SQLERRM);

Line 413: l_commit := fnd_api.g_false;

409: END IF;
410: END UPDATE_INTERFACE_TBL;
411:
412: BEGIN
413: l_commit := fnd_api.g_false;
414: l_init_msg_list := fnd_api.g_true;
415: l_validation_level := fnd_api.g_valid_level_full;
416: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
417: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;

Line 414: l_init_msg_list := fnd_api.g_true;

410: END UPDATE_INTERFACE_TBL;
411:
412: BEGIN
413: l_commit := fnd_api.g_false;
414: l_init_msg_list := fnd_api.g_true;
415: l_validation_level := fnd_api.g_valid_level_full;
416: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
417: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
418: l_fnd_g_char := FND_API.G_MISS_CHAR;

Line 415: l_validation_level := fnd_api.g_valid_level_full;

411:
412: BEGIN
413: l_commit := fnd_api.g_false;
414: l_init_msg_list := fnd_api.g_true;
415: l_validation_level := fnd_api.g_valid_level_full;
416: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
417: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
418: l_fnd_g_char := FND_API.G_MISS_CHAR;
419: l_fnd_g_num := FND_API.G_MISS_NUM;

Line 416: l_fnd_success := FND_API.G_RET_STS_SUCCESS;

412: BEGIN
413: l_commit := fnd_api.g_false;
414: l_init_msg_list := fnd_api.g_true;
415: l_validation_level := fnd_api.g_valid_level_full;
416: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
417: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
418: l_fnd_g_char := FND_API.G_MISS_CHAR;
419: l_fnd_g_num := FND_API.G_MISS_NUM;
420: l_fnd_g_date := FND_API.G_MISS_DATE;

Line 417: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;

413: l_commit := fnd_api.g_false;
414: l_init_msg_list := fnd_api.g_true;
415: l_validation_level := fnd_api.g_valid_level_full;
416: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
417: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
418: l_fnd_g_char := FND_API.G_MISS_CHAR;
419: l_fnd_g_num := FND_API.G_MISS_NUM;
420: l_fnd_g_date := FND_API.G_MISS_DATE;
421: l_fnd_g_true := FND_API.G_TRUE;

Line 418: l_fnd_g_char := FND_API.G_MISS_CHAR;

414: l_init_msg_list := fnd_api.g_true;
415: l_validation_level := fnd_api.g_valid_level_full;
416: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
417: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
418: l_fnd_g_char := FND_API.G_MISS_CHAR;
419: l_fnd_g_num := FND_API.G_MISS_NUM;
420: l_fnd_g_date := FND_API.G_MISS_DATE;
421: l_fnd_g_true := FND_API.G_TRUE;
422: l_fnd_g_false := FND_API.G_FALSE; --bug#13072088

Line 419: l_fnd_g_num := FND_API.G_MISS_NUM;

415: l_validation_level := fnd_api.g_valid_level_full;
416: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
417: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
418: l_fnd_g_char := FND_API.G_MISS_CHAR;
419: l_fnd_g_num := FND_API.G_MISS_NUM;
420: l_fnd_g_date := FND_API.G_MISS_DATE;
421: l_fnd_g_true := FND_API.G_TRUE;
422: l_fnd_g_false := FND_API.G_FALSE; --bug#13072088
423:

Line 420: l_fnd_g_date := FND_API.G_MISS_DATE;

416: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
417: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
418: l_fnd_g_char := FND_API.G_MISS_CHAR;
419: l_fnd_g_num := FND_API.G_MISS_NUM;
420: l_fnd_g_date := FND_API.G_MISS_DATE;
421: l_fnd_g_true := FND_API.G_TRUE;
422: l_fnd_g_false := FND_API.G_FALSE; --bug#13072088
423:
424: IF(l_debug_level>1) THEN

Line 421: l_fnd_g_true := FND_API.G_TRUE;

417: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
418: l_fnd_g_char := FND_API.G_MISS_CHAR;
419: l_fnd_g_num := FND_API.G_MISS_NUM;
420: l_fnd_g_date := FND_API.G_MISS_DATE;
421: l_fnd_g_true := FND_API.G_TRUE;
422: l_fnd_g_false := FND_API.G_FALSE; --bug#13072088
423:
424: IF(l_debug_level>1) THEN
425:

Line 422: l_fnd_g_false := FND_API.G_FALSE; --bug#13072088

418: l_fnd_g_char := FND_API.G_MISS_CHAR;
419: l_fnd_g_num := FND_API.G_MISS_NUM;
420: l_fnd_g_date := FND_API.G_MISS_DATE;
421: l_fnd_g_true := FND_API.G_TRUE;
422: l_fnd_g_false := FND_API.G_FALSE; --bug#13072088
423:
424: IF(l_debug_level>1) THEN
425:
426: FND_File.Put_Line(Fnd_File.LOG,'Process_iface_txns-P_Source_System_Name : '||p_source_system_name);

Line 1734: iparty_det_rec.contact_party_id <> fnd_api.g_miss_num

1730: -- Added the following code to handle contacts.
1731: -- If contact_party_id is passed then I assume
1732: -- a contact should be created for the party.
1733: IF iparty_det_rec.contact_party_id IS NOT NULL AND
1734: iparty_det_rec.contact_party_id <> fnd_api.g_miss_num
1735: THEN
1736: prty_idx:=prty_idx + 1;
1737: c_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;
1738: c_party_tbl(prty_idx).instance_id:=fnd_api.g_miss_num;

Line 1737: c_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;

1733: IF iparty_det_rec.contact_party_id IS NOT NULL AND
1734: iparty_det_rec.contact_party_id <> fnd_api.g_miss_num
1735: THEN
1736: prty_idx:=prty_idx + 1;
1737: c_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;
1738: c_party_tbl(prty_idx).instance_id:=fnd_api.g_miss_num;
1739: c_party_tbl(prty_idx).party_source_table:=iparty_det_rec.party_source_table;
1740: c_party_tbl(prty_idx).party_id:=iparty_det_rec.contact_party_id;
1741: c_party_tbl(prty_idx).relationship_type_code:=iparty_det_rec.contact_party_rel_type;

Line 1738: c_party_tbl(prty_idx).instance_id:=fnd_api.g_miss_num;

1734: iparty_det_rec.contact_party_id <> fnd_api.g_miss_num
1735: THEN
1736: prty_idx:=prty_idx + 1;
1737: c_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;
1738: c_party_tbl(prty_idx).instance_id:=fnd_api.g_miss_num;
1739: c_party_tbl(prty_idx).party_source_table:=iparty_det_rec.party_source_table;
1740: c_party_tbl(prty_idx).party_id:=iparty_det_rec.contact_party_id;
1741: c_party_tbl(prty_idx).relationship_type_code:=iparty_det_rec.contact_party_rel_type;
1742: c_party_tbl(prty_idx).contact_flag:='Y';

Line 2881: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

2877: THEN
2878: l_msg_index := 1;
2879: l_Error_Message := l_Msg_Data;
2880: WHILE l_msg_count > 0 LOOP
2881: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
2882: l_msg_index := l_msg_index + 1;
2883: l_Msg_Count := l_Msg_Count - 1;
2884: END LOOP;
2885: SAVEPOINT s_txnmiddle;

Line 2943: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

2939: l_msg_index := 1;
2940: l_Error_Message := l_Msg_Data;
2941: WHILE l_msg_count > 0
2942: LOOP
2943: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
2944: l_msg_index := l_msg_index + 1;
2945: l_Msg_Count := l_Msg_Count - 1;
2946: END LOOP;
2947: SAVEPOINT s_txnmiddle;

Line 3136: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

3132: THEN
3133: l_msg_index := 1;
3134: l_Error_Message := l_Msg_Data;
3135: WHILE l_msg_count > 0 LOOP
3136: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
3137: l_msg_index := l_msg_index + 1;
3138: l_Msg_Count := l_Msg_Count - 1;
3139: END LOOP;
3140: RAISE g_exc_error;

Line 3164: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

3160: THEN
3161: l_msg_index := 1;
3162: l_Error_Message := l_Msg_Data;
3163: WHILE l_msg_count > 0 LOOP
3164: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
3165: l_msg_index := l_msg_index + 1;
3166: l_Msg_Count := l_Msg_Count - 1;
3167: END LOOP;
3168: RAISE g_exc_error;

Line 3201: l_return_status := fnd_api.g_ret_sts_success;

3197: l_failure_count := l_failure_count +1;
3198: END;
3199: END LOOP;
3200:
3201: l_return_status := fnd_api.g_ret_sts_success;
3202:
3203: IF(l_debug_level>1) THEN
3204: FND_File.Put_Line(Fnd_File.LOG,'No of Transactions Processed :'||l_txn_count);
3205: FND_File.Put_Line(Fnd_File.LOG,'No of successful Transactions :'||l_success_count);

Line 3279: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

3275: THEN
3276: l_msg_index := 1;
3277: l_Error_Message := l_Msg_Data;
3278: WHILE l_msg_count > 0 LOOP
3279: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
3280: l_msg_index := l_msg_index + 1;
3281: l_Msg_Count := l_Msg_Count - 1;
3282: END LOOP;
3283: --RAISE g_exc_error;

Line 3420: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

3416: THEN
3417: l_msg_index := 1;
3418: l_Error_Message := l_Msg_Data;
3419: WHILE l_msg_count > 0 LOOP
3420: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
3421: l_msg_index := l_msg_index + 1;
3422: l_Msg_Count := l_Msg_Count - 1;
3423: END LOOP;
3424: --RAISE g_exc_error;