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.CSD_UPDATE_PROGRAMS_PVT dependencies on FND_GLOBAL

Line 546: p_CREATED_BY => fnd_global.user_id,

542: p_REQUEST_ID => p_activity_rec.request_id,
543: p_PROGRAM_ID => p_activity_rec.program_id,
544: p_PROGRAM_APPLICATION_ID => p_activity_rec.program_application_id,
545: p_PROGRAM_UPDATE_DATE => p_activity_rec.program_update_date,
546: p_CREATED_BY => fnd_global.user_id,
547: p_CREATION_DATE => sysdate,
548: p_LAST_UPDATED_BY => fnd_global.user_id,
549: p_LAST_UPDATE_DATE => sysdate,
550: p_REPAIR_LINE_ID => p_activity_rec.repair_line_id,

Line 548: p_LAST_UPDATED_BY => fnd_global.user_id,

544: p_PROGRAM_APPLICATION_ID => p_activity_rec.program_application_id,
545: p_PROGRAM_UPDATE_DATE => p_activity_rec.program_update_date,
546: p_CREATED_BY => fnd_global.user_id,
547: p_CREATION_DATE => sysdate,
548: p_LAST_UPDATED_BY => fnd_global.user_id,
549: p_LAST_UPDATE_DATE => sysdate,
550: p_REPAIR_LINE_ID => p_activity_rec.repair_line_id,
551: p_EVENT_CODE => p_activity_rec.event_code,
552: p_EVENT_DATE => p_activity_rec.event_date,

Line 960: last_updated_by = fnd_global.user_id,

956: update csd_repair_job_xref
957: set quantity_completed = nvl(quantity_completed,0) + 1,
958: object_version_number = object_version_number+1,
959: last_update_date = sysdate,
960: last_updated_by = fnd_global.user_id,
961: last_update_login = fnd_global.login_id
962: where repair_job_xref_id = JOB.repair_job_xref_id;
963: IF SQL%NOTFOUND THEN
964: IF ( l_error_level >= G_debug_level) THEN

Line 961: last_update_login = fnd_global.login_id

957: set quantity_completed = nvl(quantity_completed,0) + 1,
958: object_version_number = object_version_number+1,
959: last_update_date = sysdate,
960: last_updated_by = fnd_global.user_id,
961: last_update_login = fnd_global.login_id
962: where repair_job_xref_id = JOB.repair_job_xref_id;
963: IF SQL%NOTFOUND THEN
964: IF ( l_error_level >= G_debug_level) THEN
965: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

Line 1083: last_updated_by = fnd_global.user_id,

1079: update csd_repair_job_xref
1080: set quantity_completed = nvl(quantity_completed,0) + 1,
1081: object_version_number = object_version_number+1,
1082: last_update_date = sysdate,
1083: last_updated_by = fnd_global.user_id,
1084: last_update_login = fnd_global.login_id
1085: where repair_job_xref_id = JOB.repair_job_xref_id;
1086: IF SQL%NOTFOUND THEN
1087: IF ( l_error_level >= G_debug_level) THEN

Line 1084: last_update_login = fnd_global.login_id

1080: set quantity_completed = nvl(quantity_completed,0) + 1,
1081: object_version_number = object_version_number+1,
1082: last_update_date = sysdate,
1083: last_updated_by = fnd_global.user_id,
1084: last_update_login = fnd_global.login_id
1085: where repair_job_xref_id = JOB.repair_job_xref_id;
1086: IF SQL%NOTFOUND THEN
1087: IF ( l_error_level >= G_debug_level) THEN
1088: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

Line 1215: last_updated_by = fnd_global.user_id,

1211: update csd_repair_job_xref
1212: set quantity_completed = nvl(quantity_completed,0) + 1,
1213: object_version_number = object_version_number+1,
1214: last_update_date = sysdate,
1215: last_updated_by = fnd_global.user_id,
1216: last_update_login = fnd_global.login_id
1217: where repair_job_xref_id = JOB.repair_job_xref_id;
1218: IF SQL%NOTFOUND THEN
1219: IF ( l_error_level >= G_debug_level) THEN

Line 1216: last_update_login = fnd_global.login_id

1212: set quantity_completed = nvl(quantity_completed,0) + 1,
1213: object_version_number = object_version_number+1,
1214: last_update_date = sysdate,
1215: last_updated_by = fnd_global.user_id,
1216: last_update_login = fnd_global.login_id
1217: where repair_job_xref_id = JOB.repair_job_xref_id;
1218: IF SQL%NOTFOUND THEN
1219: IF ( l_error_level >= G_debug_level) THEN
1220: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

Line 1332: last_updated_by = fnd_global.user_id,

1328: update csd_repair_job_xref
1329: set quantity_completed = nvl(quantity_completed,0) + NVL(l_update_qty,0),
1330: object_version_number = object_version_number+1,
1331: last_update_date = sysdate,
1332: last_updated_by = fnd_global.user_id,
1333: last_update_login = fnd_global.login_id
1334: where repair_job_xref_id = JOB.repair_job_xref_id;
1335: IF SQL%NOTFOUND THEN
1336: IF ( l_error_level >= G_debug_level) THEN

Line 1333: last_update_login = fnd_global.login_id

1329: set quantity_completed = nvl(quantity_completed,0) + NVL(l_update_qty,0),
1330: object_version_number = object_version_number+1,
1331: last_update_date = sysdate,
1332: last_updated_by = fnd_global.user_id,
1333: last_update_login = fnd_global.login_id
1334: where repair_job_xref_id = JOB.repair_job_xref_id;
1335: IF SQL%NOTFOUND THEN
1336: IF ( l_error_level >= G_debug_level) THEN
1337: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

Line 1707: last_updated_by = fnd_global.user_id,

1703: Update csd_repair_job_xref
1704: set wip_entity_id = K.wip_entity_id,
1705: object_version_number = object_version_number+1,
1706: last_update_date = sysdate,
1707: last_updated_by = fnd_global.user_id,
1708: last_update_login = fnd_global.login_id
1709: where repair_job_xref_id = K.repair_job_xref_id;
1710: IF SQL%NOTFOUND THEN
1711: IF ( l_error_level >= G_debug_level) THEN

Line 1708: last_update_login = fnd_global.login_id

1704: set wip_entity_id = K.wip_entity_id,
1705: object_version_number = object_version_number+1,
1706: last_update_date = sysdate,
1707: last_updated_by = fnd_global.user_id,
1708: last_update_login = fnd_global.login_id
1709: where repair_job_xref_id = K.repair_job_xref_id;
1710: IF SQL%NOTFOUND THEN
1711: IF ( l_error_level >= G_debug_level) THEN
1712: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

Line 1727: last_updated_by = fnd_global.user_id,

1723: -- Updating repair order with the Job allocated qty
1724: Update csd_repairs
1725: set quantity_in_wip = NVL(quantity_in_wip,0) + K.allocated_job_qty,
1726: last_update_date = sysdate,
1727: last_updated_by = fnd_global.user_id,
1728: object_version_number = object_version_number+1,
1729: last_update_login = fnd_global.login_id
1730: where repair_line_id = K.repair_line_id;
1731: IF SQL%NOTFOUND THEN

Line 1729: last_update_login = fnd_global.login_id

1725: set quantity_in_wip = NVL(quantity_in_wip,0) + K.allocated_job_qty,
1726: last_update_date = sysdate,
1727: last_updated_by = fnd_global.user_id,
1728: object_version_number = object_version_number+1,
1729: last_update_login = fnd_global.login_id
1730: where repair_line_id = K.repair_line_id;
1731: IF SQL%NOTFOUND THEN
1732: IF ( l_error_level >= G_debug_level) THEN
1733: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 2813: last_updated_by = fnd_global.user_id,

2809: object_version_number = object_version_number+1,
2810: customer_product_id = l_instance_id,
2811: serial_number = l_st_serial_num,
2812: last_update_date = sysdate,
2813: last_updated_by = fnd_global.user_id,
2814: last_update_login = fnd_global.login_id
2815: where repair_line_id = I.repair_line_id;
2816: IF SQL%NOTFOUND THEN
2817: IF ( l_error_level >= G_debug_level) THEN

Line 2814: last_update_login = fnd_global.login_id

2810: customer_product_id = l_instance_id,
2811: serial_number = l_st_serial_num,
2812: last_update_date = sysdate,
2813: last_updated_by = fnd_global.user_id,
2814: last_update_login = fnd_global.login_id
2815: where repair_line_id = I.repair_line_id;
2816: IF SQL%NOTFOUND THEN
2817: IF ( l_error_level >= G_debug_level) THEN
2818: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 2836: last_updated_by = fnd_global.user_id,

2832: update csd_repairs
2833: set quantity_rcvd = nvl(quantity_rcvd,0)+ l_result_quantity,
2834: object_version_number = object_version_number+1,
2835: last_update_date = sysdate,
2836: last_updated_by = fnd_global.user_id,
2837: last_update_login = fnd_global.login_id
2838: where repair_line_id = I.repair_line_id;
2839: IF SQL%NOTFOUND THEN
2840: IF ( l_error_level >= G_debug_level) THEN

Line 2837: last_update_login = fnd_global.login_id

2833: set quantity_rcvd = nvl(quantity_rcvd,0)+ l_result_quantity,
2834: object_version_number = object_version_number+1,
2835: last_update_date = sysdate,
2836: last_updated_by = fnd_global.user_id,
2837: last_update_login = fnd_global.login_id
2838: where repair_line_id = I.repair_line_id;
2839: IF SQL%NOTFOUND THEN
2840: IF ( l_error_level >= G_debug_level) THEN
2841: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 2872: last_updated_by = fnd_global.user_id,

2868: quantity_received = nvl(quantity_received,0) + nvl(I.received_quantity,0),
2869: prod_txn_status = l_prod_txn_status,
2870: object_version_number = object_version_number+1,
2871: last_update_date = sysdate,
2872: last_updated_by = fnd_global.user_id,
2873: last_update_login = fnd_global.login_id
2874: WHERE product_transaction_id = i.product_transaction_id;
2875: IF SQL%NOTFOUND THEN
2876: IF ( l_error_level >= G_debug_level) THEN

Line 2873: last_update_login = fnd_global.login_id

2869: prod_txn_status = l_prod_txn_status,
2870: object_version_number = object_version_number+1,
2871: last_update_date = sysdate,
2872: last_updated_by = fnd_global.user_id,
2873: last_update_login = fnd_global.login_id
2874: WHERE product_transaction_id = i.product_transaction_id;
2875: IF SQL%NOTFOUND THEN
2876: IF ( l_error_level >= G_debug_level) THEN
2877: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 3639: last_updated_by = fnd_global.user_id,

3635: quantity_rcvd = nvl(quantity_rcvd,0) + l_rcvd_qty,
3636: customer_product_id = l_instance_id,
3637: object_version_number = object_version_number+1,
3638: last_update_date = sysdate,
3639: last_updated_by = fnd_global.user_id,
3640: last_update_login = fnd_global.login_id
3641: WHERE repair_line_id = RO.repair_line_id;
3642: IF SQL%NOTFOUND THEN
3643: IF ( l_error_level >= G_debug_level) THEN

Line 3640: last_update_login = fnd_global.login_id

3636: customer_product_id = l_instance_id,
3637: object_version_number = object_version_number+1,
3638: last_update_date = sysdate,
3639: last_updated_by = fnd_global.user_id,
3640: last_update_login = fnd_global.login_id
3641: WHERE repair_line_id = RO.repair_line_id;
3642: IF SQL%NOTFOUND THEN
3643: IF ( l_error_level >= G_debug_level) THEN
3644: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 3668: last_updated_by = fnd_global.user_id,

3664: QUANTITY_RECEIVED = NVL(QUANTITY_RECEIVED,0) + l_rcvd_qty,
3665: SUB_INVENTORY_RCVD = DEL.subinventory,
3666: object_version_number = object_version_number+1,
3667: last_update_date = sysdate,
3668: last_updated_by = fnd_global.user_id,
3669: last_update_login = fnd_global.login_id
3670: WHERE product_transaction_id = RO.product_transaction_id;
3671: IF SQL%NOTFOUND THEN
3672: IF ( l_error_level >= G_debug_level) THEN

Line 3669: last_update_login = fnd_global.login_id

3665: SUB_INVENTORY_RCVD = DEL.subinventory,
3666: object_version_number = object_version_number+1,
3667: last_update_date = sysdate,
3668: last_updated_by = fnd_global.user_id,
3669: last_update_login = fnd_global.login_id
3670: WHERE product_transaction_id = RO.product_transaction_id;
3671: IF SQL%NOTFOUND THEN
3672: IF ( l_error_level >= G_debug_level) THEN
3673: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 3689: last_updated_by = fnd_global.user_id,

3685: UPDATE CSD_PRODUCT_TRANSACTIONS
3686: SET prod_txn_status = 'RECEIVED',
3687: object_version_number = object_version_number+1,
3688: last_update_date = sysdate,
3689: last_updated_by = fnd_global.user_id,
3690: last_update_login = fnd_global.login_id
3691: WHERE product_transaction_id = RO.product_transaction_id;
3692: ELSE
3693: UPDATE CSD_PRODUCT_TRANSACTIONS

Line 3690: last_update_login = fnd_global.login_id

3686: SET prod_txn_status = 'RECEIVED',
3687: object_version_number = object_version_number+1,
3688: last_update_date = sysdate,
3689: last_updated_by = fnd_global.user_id,
3690: last_update_login = fnd_global.login_id
3691: WHERE product_transaction_id = RO.product_transaction_id;
3692: ELSE
3693: UPDATE CSD_PRODUCT_TRANSACTIONS
3694: SET prod_txn_status = 'RECEIVED',

Line 3697: last_updated_by = fnd_global.user_id,

3693: UPDATE CSD_PRODUCT_TRANSACTIONS
3694: SET prod_txn_status = 'RECEIVED',
3695: object_version_number = object_version_number+1,
3696: last_update_date = sysdate,
3697: last_updated_by = fnd_global.user_id,
3698: last_update_login = fnd_global.login_id
3699: WHERE quantity_received = RO.ordered_quantity
3700: and product_transaction_id = RO.product_transaction_id;
3701: END IF;

Line 3698: last_update_login = fnd_global.login_id

3694: SET prod_txn_status = 'RECEIVED',
3695: object_version_number = object_version_number+1,
3696: last_update_date = sysdate,
3697: last_updated_by = fnd_global.user_id,
3698: last_update_login = fnd_global.login_id
3699: WHERE quantity_received = RO.ordered_quantity
3700: and product_transaction_id = RO.product_transaction_id;
3701: END IF;
3702:

Line 4007: last_updated_by = fnd_global.user_id,

4003: quantity_rcvd = nvl(quantity_rcvd,0) + l_rcvd_qty,
4004: customer_product_id = l_instance_id,
4005: object_version_number = object_version_number+1,
4006: last_update_date = sysdate,
4007: last_updated_by = fnd_global.user_id,
4008: last_update_login = fnd_global.login_id
4009: WHERE repair_line_id = RO.repair_line_id;
4010: IF SQL%NOTFOUND THEN
4011: IF ( l_error_level >= G_debug_level) THEN

Line 4008: last_update_login = fnd_global.login_id

4004: customer_product_id = l_instance_id,
4005: object_version_number = object_version_number+1,
4006: last_update_date = sysdate,
4007: last_updated_by = fnd_global.user_id,
4008: last_update_login = fnd_global.login_id
4009: WHERE repair_line_id = RO.repair_line_id;
4010: IF SQL%NOTFOUND THEN
4011: IF ( l_error_level >= G_debug_level) THEN
4012: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 4037: last_updated_by = fnd_global.user_id,

4033: QUANTITY_RECEIVED = NVL(QUANTITY_RECEIVED,0) + l_rcvd_qty,
4034: SUB_INVENTORY_RCVD = DEL.subinventory,
4035: object_version_number = object_version_number+1,
4036: last_update_date = sysdate,
4037: last_updated_by = fnd_global.user_id,
4038: last_update_login = fnd_global.login_id
4039: WHERE product_transaction_id = RO.product_transaction_id;
4040: IF SQL%NOTFOUND THEN
4041: IF ( l_error_level >= G_debug_level) THEN

Line 4038: last_update_login = fnd_global.login_id

4034: SUB_INVENTORY_RCVD = DEL.subinventory,
4035: object_version_number = object_version_number+1,
4036: last_update_date = sysdate,
4037: last_updated_by = fnd_global.user_id,
4038: last_update_login = fnd_global.login_id
4039: WHERE product_transaction_id = RO.product_transaction_id;
4040: IF SQL%NOTFOUND THEN
4041: IF ( l_error_level >= G_debug_level) THEN
4042: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 4058: last_updated_by = fnd_global.user_id,

4054: UPDATE CSD_PRODUCT_TRANSACTIONS
4055: SET prod_txn_status = 'RECEIVED',
4056: object_version_number = object_version_number+1,
4057: last_update_date = sysdate,
4058: last_updated_by = fnd_global.user_id,
4059: last_update_login = fnd_global.login_id
4060: WHERE product_transaction_id = RO.product_transaction_id;
4061:
4062: ELSE

Line 4059: last_update_login = fnd_global.login_id

4055: SET prod_txn_status = 'RECEIVED',
4056: object_version_number = object_version_number+1,
4057: last_update_date = sysdate,
4058: last_updated_by = fnd_global.user_id,
4059: last_update_login = fnd_global.login_id
4060: WHERE product_transaction_id = RO.product_transaction_id;
4061:
4062: ELSE
4063: UPDATE CSD_PRODUCT_TRANSACTIONS

Line 4067: last_updated_by = fnd_global.user_id,

4063: UPDATE CSD_PRODUCT_TRANSACTIONS
4064: SET prod_txn_status = 'RECEIVED',
4065: object_version_number = object_version_number+1,
4066: last_update_date = sysdate,
4067: last_updated_by = fnd_global.user_id,
4068: last_update_login = fnd_global.login_id
4069: WHERE quantity_received = RO.ordered_quantity
4070: and product_transaction_id = RO.product_transaction_id;
4071: END IF;

Line 4068: last_update_login = fnd_global.login_id

4064: SET prod_txn_status = 'RECEIVED',
4065: object_version_number = object_version_number+1,
4066: last_update_date = sysdate,
4067: last_updated_by = fnd_global.user_id,
4068: last_update_login = fnd_global.login_id
4069: WHERE quantity_received = RO.ordered_quantity
4070: and product_transaction_id = RO.product_transaction_id;
4071: END IF;
4072:

Line 4282: last_updated_by = fnd_global.user_id,

4278: quantity_rcvd = nvl(quantity_rcvd,0) + l_rcvd_qty,
4279: customer_product_id = l_instance_id,
4280: object_version_number = object_version_number+1,
4281: last_update_date = sysdate,
4282: last_updated_by = fnd_global.user_id,
4283: last_update_login = fnd_global.login_id
4284: WHERE repair_line_id = RO.repair_line_id;
4285: IF SQL%NOTFOUND THEN
4286: IF ( l_error_level >= G_debug_level) THEN

Line 4283: last_update_login = fnd_global.login_id

4279: customer_product_id = l_instance_id,
4280: object_version_number = object_version_number+1,
4281: last_update_date = sysdate,
4282: last_updated_by = fnd_global.user_id,
4283: last_update_login = fnd_global.login_id
4284: WHERE repair_line_id = RO.repair_line_id;
4285: IF SQL%NOTFOUND THEN
4286: IF ( l_error_level >= G_debug_level) THEN
4287: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 4310: last_updated_by = fnd_global.user_id,

4306: SUB_INVENTORY_RCVD= RCV.subinventory,
4307: LOCATOR_ID = RCV.locator_id,
4308: object_version_number = object_version_number+1,
4309: last_update_date = sysdate,
4310: last_updated_by = fnd_global.user_id,
4311: last_update_login = fnd_global.login_id
4312: WHERE product_transaction_id = RO.product_transaction_id;
4313: IF SQL%NOTFOUND THEN
4314: IF ( l_error_level >= G_debug_level) THEN

Line 4311: last_update_login = fnd_global.login_id

4307: LOCATOR_ID = RCV.locator_id,
4308: object_version_number = object_version_number+1,
4309: last_update_date = sysdate,
4310: last_updated_by = fnd_global.user_id,
4311: last_update_login = fnd_global.login_id
4312: WHERE product_transaction_id = RO.product_transaction_id;
4313: IF SQL%NOTFOUND THEN
4314: IF ( l_error_level >= G_debug_level) THEN
4315: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 4331: last_updated_by = fnd_global.user_id,

4327: UPDATE CSD_PRODUCT_TRANSACTIONS
4328: SET prod_txn_status = 'RECEIVED',
4329: object_version_number = object_version_number+1,
4330: last_update_date = sysdate,
4331: last_updated_by = fnd_global.user_id,
4332: last_update_login = fnd_global.login_id
4333: WHERE product_transaction_id = RO.product_transaction_id;
4334: ELSE
4335: UPDATE CSD_PRODUCT_TRANSACTIONS

Line 4332: last_update_login = fnd_global.login_id

4328: SET prod_txn_status = 'RECEIVED',
4329: object_version_number = object_version_number+1,
4330: last_update_date = sysdate,
4331: last_updated_by = fnd_global.user_id,
4332: last_update_login = fnd_global.login_id
4333: WHERE product_transaction_id = RO.product_transaction_id;
4334: ELSE
4335: UPDATE CSD_PRODUCT_TRANSACTIONS
4336: SET prod_txn_status = 'RECEIVED',

Line 4339: last_updated_by = fnd_global.user_id,

4335: UPDATE CSD_PRODUCT_TRANSACTIONS
4336: SET prod_txn_status = 'RECEIVED',
4337: object_version_number = object_version_number+1,
4338: last_update_date = sysdate,
4339: last_updated_by = fnd_global.user_id,
4340: last_update_login = fnd_global.login_id
4341: WHERE quantity_received = RO.ordered_quantity
4342: and product_transaction_id = RO.product_transaction_id;
4343: END IF;

Line 4340: last_update_login = fnd_global.login_id

4336: SET prod_txn_status = 'RECEIVED',
4337: object_version_number = object_version_number+1,
4338: last_update_date = sysdate,
4339: last_updated_by = fnd_global.user_id,
4340: last_update_login = fnd_global.login_id
4341: WHERE quantity_received = RO.ordered_quantity
4342: and product_transaction_id = RO.product_transaction_id;
4343: END IF;
4344:

Line 5060: last_updated_by = fnd_global.user_id,

5056: quantity_rcvd = nvl(quantity_rcvd,0) + l_rcvd_qty,
5057: customer_product_id = l_instance_id,
5058: object_version_number = object_version_number+1,
5059: last_update_date = sysdate,
5060: last_updated_by = fnd_global.user_id,
5061: last_update_login = fnd_global.login_id
5062: WHERE repair_line_id = RO.repair_line_id;
5063: IF SQL%NOTFOUND THEN
5064: IF ( l_error_level >= G_debug_level) THEN

Line 5061: last_update_login = fnd_global.login_id

5057: customer_product_id = l_instance_id,
5058: object_version_number = object_version_number+1,
5059: last_update_date = sysdate,
5060: last_updated_by = fnd_global.user_id,
5061: last_update_login = fnd_global.login_id
5062: WHERE repair_line_id = RO.repair_line_id;
5063: IF SQL%NOTFOUND THEN
5064: IF ( l_error_level >= G_debug_level) THEN
5065: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 5089: last_updated_by = fnd_global.user_id,

5085: QUANTITY_RECEIVED = NVL(QUANTITY_RECEIVED,0) + l_rcvd_qty,
5086: SUB_INVENTORY_RCVD = DEL.subinventory,
5087: object_version_number = object_version_number+1,
5088: last_update_date = sysdate,
5089: last_updated_by = fnd_global.user_id,
5090: last_update_login = fnd_global.login_id
5091: WHERE product_transaction_id = RO.product_transaction_id;
5092: IF SQL%NOTFOUND THEN
5093: IF ( l_error_level >= G_debug_level) THEN

Line 5090: last_update_login = fnd_global.login_id

5086: SUB_INVENTORY_RCVD = DEL.subinventory,
5087: object_version_number = object_version_number+1,
5088: last_update_date = sysdate,
5089: last_updated_by = fnd_global.user_id,
5090: last_update_login = fnd_global.login_id
5091: WHERE product_transaction_id = RO.product_transaction_id;
5092: IF SQL%NOTFOUND THEN
5093: IF ( l_error_level >= G_debug_level) THEN
5094: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 5110: last_updated_by = fnd_global.user_id,

5106: UPDATE CSD_PRODUCT_TRANSACTIONS
5107: SET prod_txn_status = 'RECEIVED',
5108: object_version_number = object_version_number+1,
5109: last_update_date = sysdate,
5110: last_updated_by = fnd_global.user_id,
5111: last_update_login = fnd_global.login_id
5112: WHERE product_transaction_id = RO.product_transaction_id;
5113: ELSE
5114: UPDATE CSD_PRODUCT_TRANSACTIONS

Line 5111: last_update_login = fnd_global.login_id

5107: SET prod_txn_status = 'RECEIVED',
5108: object_version_number = object_version_number+1,
5109: last_update_date = sysdate,
5110: last_updated_by = fnd_global.user_id,
5111: last_update_login = fnd_global.login_id
5112: WHERE product_transaction_id = RO.product_transaction_id;
5113: ELSE
5114: UPDATE CSD_PRODUCT_TRANSACTIONS
5115: SET prod_txn_status = 'RECEIVED',

Line 5118: last_updated_by = fnd_global.user_id,

5114: UPDATE CSD_PRODUCT_TRANSACTIONS
5115: SET prod_txn_status = 'RECEIVED',
5116: object_version_number = object_version_number+1,
5117: last_update_date = sysdate,
5118: last_updated_by = fnd_global.user_id,
5119: last_update_login = fnd_global.login_id
5120: WHERE quantity_received = RO.ordered_quantity
5121: and product_transaction_id = RO.product_transaction_id;
5122: END IF;

Line 5119: last_update_login = fnd_global.login_id

5115: SET prod_txn_status = 'RECEIVED',
5116: object_version_number = object_version_number+1,
5117: last_update_date = sysdate,
5118: last_updated_by = fnd_global.user_id,
5119: last_update_login = fnd_global.login_id
5120: WHERE quantity_received = RO.ordered_quantity
5121: and product_transaction_id = RO.product_transaction_id;
5122: END IF;
5123:

Line 5433: last_updated_by = fnd_global.user_id,

5429: quantity_rcvd = nvl(quantity_rcvd,0) + l_rcvd_qty,
5430: customer_product_id = l_instance_id,
5431: object_version_number = object_version_number+1,
5432: last_update_date = sysdate,
5433: last_updated_by = fnd_global.user_id,
5434: last_update_login = fnd_global.login_id
5435: WHERE repair_line_id = RO.repair_line_id;
5436: IF SQL%NOTFOUND THEN
5437: IF ( l_error_level >= G_debug_level) THEN

Line 5434: last_update_login = fnd_global.login_id

5430: customer_product_id = l_instance_id,
5431: object_version_number = object_version_number+1,
5432: last_update_date = sysdate,
5433: last_updated_by = fnd_global.user_id,
5434: last_update_login = fnd_global.login_id
5435: WHERE repair_line_id = RO.repair_line_id;
5436: IF SQL%NOTFOUND THEN
5437: IF ( l_error_level >= G_debug_level) THEN
5438: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 5463: last_updated_by = fnd_global.user_id,

5459: QUANTITY_RECEIVED = NVL(QUANTITY_RECEIVED,0) + l_rcvd_qty,
5460: SUB_INVENTORY_RCVD = DEL.subinventory,
5461: object_version_number = object_version_number+1,
5462: last_update_date = sysdate,
5463: last_updated_by = fnd_global.user_id,
5464: last_update_login = fnd_global.login_id
5465: WHERE product_transaction_id = RO.product_transaction_id;
5466: IF SQL%NOTFOUND THEN
5467: IF ( l_error_level >= G_debug_level) THEN

Line 5464: last_update_login = fnd_global.login_id

5460: SUB_INVENTORY_RCVD = DEL.subinventory,
5461: object_version_number = object_version_number+1,
5462: last_update_date = sysdate,
5463: last_updated_by = fnd_global.user_id,
5464: last_update_login = fnd_global.login_id
5465: WHERE product_transaction_id = RO.product_transaction_id;
5466: IF SQL%NOTFOUND THEN
5467: IF ( l_error_level >= G_debug_level) THEN
5468: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 5484: last_updated_by = fnd_global.user_id,

5480: UPDATE CSD_PRODUCT_TRANSACTIONS
5481: SET prod_txn_status = 'RECEIVED',
5482: object_version_number = object_version_number+1,
5483: last_update_date = sysdate,
5484: last_updated_by = fnd_global.user_id,
5485: last_update_login = fnd_global.login_id
5486: WHERE product_transaction_id = RO.product_transaction_id;
5487:
5488: ELSE

Line 5485: last_update_login = fnd_global.login_id

5481: SET prod_txn_status = 'RECEIVED',
5482: object_version_number = object_version_number+1,
5483: last_update_date = sysdate,
5484: last_updated_by = fnd_global.user_id,
5485: last_update_login = fnd_global.login_id
5486: WHERE product_transaction_id = RO.product_transaction_id;
5487:
5488: ELSE
5489: UPDATE CSD_PRODUCT_TRANSACTIONS

Line 5493: last_updated_by = fnd_global.user_id,

5489: UPDATE CSD_PRODUCT_TRANSACTIONS
5490: SET prod_txn_status = 'RECEIVED',
5491: object_version_number = object_version_number+1,
5492: last_update_date = sysdate,
5493: last_updated_by = fnd_global.user_id,
5494: last_update_login = fnd_global.login_id
5495: WHERE quantity_received = RO.ordered_quantity
5496: and product_transaction_id = RO.product_transaction_id;
5497: END IF;

Line 5494: last_update_login = fnd_global.login_id

5490: SET prod_txn_status = 'RECEIVED',
5491: object_version_number = object_version_number+1,
5492: last_update_date = sysdate,
5493: last_updated_by = fnd_global.user_id,
5494: last_update_login = fnd_global.login_id
5495: WHERE quantity_received = RO.ordered_quantity
5496: and product_transaction_id = RO.product_transaction_id;
5497: END IF;
5498:

Line 5721: last_updated_by = fnd_global.user_id,

5717: quantity_rcvd = nvl(quantity_rcvd,0) + l_rcvd_qty,
5718: customer_product_id = l_instance_id,
5719: object_version_number = object_version_number+1,
5720: last_update_date = sysdate,
5721: last_updated_by = fnd_global.user_id,
5722: last_update_login = fnd_global.login_id
5723: WHERE repair_line_id = RO.repair_line_id;
5724: IF SQL%NOTFOUND THEN
5725: IF ( l_error_level >= G_debug_level) THEN

Line 5722: last_update_login = fnd_global.login_id

5718: customer_product_id = l_instance_id,
5719: object_version_number = object_version_number+1,
5720: last_update_date = sysdate,
5721: last_updated_by = fnd_global.user_id,
5722: last_update_login = fnd_global.login_id
5723: WHERE repair_line_id = RO.repair_line_id;
5724: IF SQL%NOTFOUND THEN
5725: IF ( l_error_level >= G_debug_level) THEN
5726: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 5749: last_updated_by = fnd_global.user_id,

5745: SUB_INVENTORY_RCVD= RCV.subinventory,
5746: LOCATOR_ID = RCV.locator_id,
5747: object_version_number = object_version_number+1,
5748: last_update_date = sysdate,
5749: last_updated_by = fnd_global.user_id,
5750: last_update_login = fnd_global.login_id
5751: WHERE product_transaction_id = RO.product_transaction_id;
5752: IF SQL%NOTFOUND THEN
5753: IF ( l_error_level >= G_debug_level) THEN

Line 5750: last_update_login = fnd_global.login_id

5746: LOCATOR_ID = RCV.locator_id,
5747: object_version_number = object_version_number+1,
5748: last_update_date = sysdate,
5749: last_updated_by = fnd_global.user_id,
5750: last_update_login = fnd_global.login_id
5751: WHERE product_transaction_id = RO.product_transaction_id;
5752: IF SQL%NOTFOUND THEN
5753: IF ( l_error_level >= G_debug_level) THEN
5754: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 5770: last_updated_by = fnd_global.user_id,

5766: UPDATE CSD_PRODUCT_TRANSACTIONS
5767: SET prod_txn_status = 'RECEIVED',
5768: object_version_number = object_version_number+1,
5769: last_update_date = sysdate,
5770: last_updated_by = fnd_global.user_id,
5771: last_update_login = fnd_global.login_id
5772: WHERE product_transaction_id = RO.product_transaction_id;
5773: ELSE
5774: UPDATE CSD_PRODUCT_TRANSACTIONS

Line 5771: last_update_login = fnd_global.login_id

5767: SET prod_txn_status = 'RECEIVED',
5768: object_version_number = object_version_number+1,
5769: last_update_date = sysdate,
5770: last_updated_by = fnd_global.user_id,
5771: last_update_login = fnd_global.login_id
5772: WHERE product_transaction_id = RO.product_transaction_id;
5773: ELSE
5774: UPDATE CSD_PRODUCT_TRANSACTIONS
5775: SET prod_txn_status = 'RECEIVED',

Line 5778: last_updated_by = fnd_global.user_id,

5774: UPDATE CSD_PRODUCT_TRANSACTIONS
5775: SET prod_txn_status = 'RECEIVED',
5776: object_version_number = object_version_number+1,
5777: last_update_date = sysdate,
5778: last_updated_by = fnd_global.user_id,
5779: last_update_login = fnd_global.login_id
5780: WHERE quantity_received = RO.ordered_quantity
5781: and product_transaction_id = RO.product_transaction_id;
5782: END IF;

Line 5779: last_update_login = fnd_global.login_id

5775: SET prod_txn_status = 'RECEIVED',
5776: object_version_number = object_version_number+1,
5777: last_update_date = sysdate,
5778: last_updated_by = fnd_global.user_id,
5779: last_update_login = fnd_global.login_id
5780: WHERE quantity_received = RO.ordered_quantity
5781: and product_transaction_id = RO.product_transaction_id;
5782: END IF;
5783:

Line 6682: last_updated_by = fnd_global.user_id,

6678: update csd_repairs
6679: set quantity_shipped = nvl(quantity_shipped,0)+l_result_ship_qty,
6680: object_version_number = object_version_number+1,
6681: last_update_date = sysdate,
6682: last_updated_by = fnd_global.user_id,
6683: last_update_login = fnd_global.login_id
6684: where repair_line_id = I.repair_line_id;
6685: IF SQL%NOTFOUND THEN
6686: IF ( l_error_level >= G_debug_level) THEN

Line 6683: last_update_login = fnd_global.login_id

6679: set quantity_shipped = nvl(quantity_shipped,0)+l_result_ship_qty,
6680: object_version_number = object_version_number+1,
6681: last_update_date = sysdate,
6682: last_updated_by = fnd_global.user_id,
6683: last_update_login = fnd_global.login_id
6684: where repair_line_id = I.repair_line_id;
6685: IF SQL%NOTFOUND THEN
6686: IF ( l_error_level >= G_debug_level) THEN
6687: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 6772: last_updated_by = fnd_global.user_id,

6768: source_serial_number = i.shipped_serial_num,
6769: source_instance_id = l_instance_id,
6770: object_version_number = object_version_number+1,
6771: last_update_date = sysdate,
6772: last_updated_by = fnd_global.user_id,
6773: last_update_login = fnd_global.login_id
6774: where product_transaction_id = i.product_transaction_id ;
6775: IF SQL%NOTFOUND THEN
6776: IF ( l_error_level >= G_debug_level) THEN

Line 6773: last_update_login = fnd_global.login_id

6769: source_instance_id = l_instance_id,
6770: object_version_number = object_version_number+1,
6771: last_update_date = sysdate,
6772: last_updated_by = fnd_global.user_id,
6773: last_update_login = fnd_global.login_id
6774: where product_transaction_id = i.product_transaction_id ;
6775: IF SQL%NOTFOUND THEN
6776: IF ( l_error_level >= G_debug_level) THEN
6777: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 6794: last_updated_by = fnd_global.user_id,

6790: update csd_product_transactions
6791: set prod_txn_status = 'SHIPPED',
6792: object_version_number = object_version_number+1,
6793: last_update_date = sysdate,
6794: last_updated_by = fnd_global.user_id,
6795: last_update_login = fnd_global.login_id
6796: where nvl(quantity_shipped,0) = I.estimate_quantity
6797: and product_transaction_id = i.product_transaction_id ;
6798:

Line 6795: last_update_login = fnd_global.login_id

6791: set prod_txn_status = 'SHIPPED',
6792: object_version_number = object_version_number+1,
6793: last_update_date = sysdate,
6794: last_updated_by = fnd_global.user_id,
6795: last_update_login = fnd_global.login_id
6796: where nvl(quantity_shipped,0) = I.estimate_quantity
6797: and product_transaction_id = i.product_transaction_id ;
6798:
6799:

Line 7386: last_updated_by = fnd_global.user_id,

7382: ship_sales_order_flag = l_ship_so_flag,
7383: prod_txn_status = l_prod_txn_status,
7384: object_version_number = object_version_number+1,
7385: last_update_date = sysdate,
7386: last_updated_by = fnd_global.user_id,
7387: last_update_login = fnd_global.login_id
7388: WHERE product_transaction_id = l_prod_txn_id;
7389: IF SQL%NOTFOUND THEN
7390: IF ( l_error_level >= G_debug_level) THEN

Line 7387: last_update_login = fnd_global.login_id

7383: prod_txn_status = l_prod_txn_status,
7384: object_version_number = object_version_number+1,
7385: last_update_date = sysdate,
7386: last_updated_by = fnd_global.user_id,
7387: last_update_login = fnd_global.login_id
7388: WHERE product_transaction_id = l_prod_txn_id;
7389: IF SQL%NOTFOUND THEN
7390: IF ( l_error_level >= G_debug_level) THEN
7391: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');

Line 7445: p_LAST_UPDATED_BY => fnd_global.user_id,

7441: p_PROD_TXN_STATUS => l_prod_txn_status,
7442: p_PROD_TXN_CODE => '',
7443: p_LAST_UPDATE_DATE => sysdate,
7444: p_CREATION_DATE => sysdate,
7445: p_LAST_UPDATED_BY => fnd_global.user_id,
7446: p_CREATED_BY => fnd_global.user_id,
7447: p_LAST_UPDATE_LOGIN => null,
7448: p_ATTRIBUTE1 => '',
7449: p_ATTRIBUTE2 => '',

Line 7446: p_CREATED_BY => fnd_global.user_id,

7442: p_PROD_TXN_CODE => '',
7443: p_LAST_UPDATE_DATE => sysdate,
7444: p_CREATION_DATE => sysdate,
7445: p_LAST_UPDATED_BY => fnd_global.user_id,
7446: p_CREATED_BY => fnd_global.user_id,
7447: p_LAST_UPDATE_LOGIN => null,
7448: p_ATTRIBUTE1 => '',
7449: p_ATTRIBUTE2 => '',
7450: p_ATTRIBUTE3 => '',

Line 7538: last_updated_by = fnd_global.user_id,

7534: lot_number = DEL.lot_number,
7535: locator_id = DEL.locator_id,
7536: object_version_number = object_version_number+1,
7537: last_update_date = sysdate,
7538: last_updated_by = fnd_global.user_id,
7539: last_update_login = fnd_global.login_id
7540: WHERE order_header_id = DEL.header_id
7541: and order_line_id = DEL.line_id
7542: and action_type = l_action_type

Line 7539: last_update_login = fnd_global.login_id

7535: locator_id = DEL.locator_id,
7536: object_version_number = object_version_number+1,
7537: last_update_date = sysdate,
7538: last_updated_by = fnd_global.user_id,
7539: last_update_login = fnd_global.login_id
7540: WHERE order_header_id = DEL.header_id
7541: and order_line_id = DEL.line_id
7542: and action_type = l_action_type
7543: and action_code = l_action_code

Line 7570: last_updated_by = fnd_global.user_id,

7566: lot_number = DEL.lot_number,
7567: locator_id = DEL.locator_id,
7568: object_version_number = object_version_number+1,
7569: last_update_date = sysdate,
7570: last_updated_by = fnd_global.user_id,
7571: last_update_login = fnd_global.login_id
7572: WHERE order_header_id = DEL.header_id
7573: and action_type = l_action_type
7574: and action_code = l_action_code

Line 7571: last_update_login = fnd_global.login_id

7567: locator_id = DEL.locator_id,
7568: object_version_number = object_version_number+1,
7569: last_update_date = sysdate,
7570: last_updated_by = fnd_global.user_id,
7571: last_update_login = fnd_global.login_id
7572: WHERE order_header_id = DEL.header_id
7573: and action_type = l_action_type
7574: and action_code = l_action_code
7575: and prod_txn_status in ('BOOKED','RELEASED')

Line 7701: last_updated_by = fnd_global.user_id,

7697: ship_sales_order_flag = l_ship_so_flag,
7698: prod_txn_status = l_prod_txn_status,
7699: object_version_number = object_version_number+1,
7700: last_update_date = sysdate,
7701: last_updated_by = fnd_global.user_id,
7702: last_update_login = fnd_global.login_id
7703: WHERE product_transaction_id = l_prod_txn_id;
7704: IF SQL%NOTFOUND THEN
7705: IF ( l_error_level >= G_debug_level) THEN

Line 7702: last_update_login = fnd_global.login_id

7698: prod_txn_status = l_prod_txn_status,
7699: object_version_number = object_version_number+1,
7700: last_update_date = sysdate,
7701: last_updated_by = fnd_global.user_id,
7702: last_update_login = fnd_global.login_id
7703: WHERE product_transaction_id = l_prod_txn_id;
7704: IF SQL%NOTFOUND THEN
7705: IF ( l_error_level >= G_debug_level) THEN
7706: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');

Line 7760: p_LAST_UPDATED_BY => fnd_global.user_id,

7756: p_PROD_TXN_STATUS => l_prod_txn_status,
7757: p_PROD_TXN_CODE => '',
7758: p_LAST_UPDATE_DATE => sysdate,
7759: p_CREATION_DATE => sysdate,
7760: p_LAST_UPDATED_BY => fnd_global.user_id,
7761: p_CREATED_BY => fnd_global.user_id,
7762: p_LAST_UPDATE_LOGIN => null,
7763: p_ATTRIBUTE1 => '',
7764: p_ATTRIBUTE2 => '',

Line 7761: p_CREATED_BY => fnd_global.user_id,

7757: p_PROD_TXN_CODE => '',
7758: p_LAST_UPDATE_DATE => sysdate,
7759: p_CREATION_DATE => sysdate,
7760: p_LAST_UPDATED_BY => fnd_global.user_id,
7761: p_CREATED_BY => fnd_global.user_id,
7762: p_LAST_UPDATE_LOGIN => null,
7763: p_ATTRIBUTE1 => '',
7764: p_ATTRIBUTE2 => '',
7765: p_ATTRIBUTE3 => '',

Line 7818: last_updated_by = fnd_global.user_id,

7814: Update csd_repairs
7815: set quantity_shipped = nvl(quantity_shipped,0) + DEL.shipped_quantity,
7816: object_version_number = object_version_number+1,
7817: last_update_date = sysdate,
7818: last_updated_by = fnd_global.user_id,
7819: last_update_login = fnd_global.login_id
7820: where repair_line_id = l_rep_line_id;
7821: IF SQL%NOTFOUND THEN
7822: IF ( l_error_level >= G_debug_level) THEN

Line 7819: last_update_login = fnd_global.login_id

7815: set quantity_shipped = nvl(quantity_shipped,0) + DEL.shipped_quantity,
7816: object_version_number = object_version_number+1,
7817: last_update_date = sysdate,
7818: last_updated_by = fnd_global.user_id,
7819: last_update_login = fnd_global.login_id
7820: where repair_line_id = l_rep_line_id;
7821: IF SQL%NOTFOUND THEN
7822: IF ( l_error_level >= G_debug_level) THEN
7823: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 7947: last_updated_by = fnd_global.user_id,

7943: order_line_id = DEL.line_id,
7944: source_serial_number = UT.serial_number,
7945: object_version_number = object_version_number+1,
7946: last_update_date = sysdate,
7947: last_updated_by = fnd_global.user_id,
7948: last_update_login = fnd_global.login_id
7949: where product_transaction_id = l_prod_txn_id;
7950: IF SQL%NOTFOUND THEN
7951: IF ( l_error_level >= G_debug_level) THEN

Line 7948: last_update_login = fnd_global.login_id

7944: source_serial_number = UT.serial_number,
7945: object_version_number = object_version_number+1,
7946: last_update_date = sysdate,
7947: last_updated_by = fnd_global.user_id,
7948: last_update_login = fnd_global.login_id
7949: where product_transaction_id = l_prod_txn_id;
7950: IF SQL%NOTFOUND THEN
7951: IF ( l_error_level >= G_debug_level) THEN
7952: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');

Line 7968: last_updated_by = fnd_global.user_id,

7964: Update csd_repairs
7965: set quantity_shipped = 1,
7966: object_version_number = object_version_number+1,
7967: last_update_date = sysdate,
7968: last_updated_by = fnd_global.user_id,
7969: last_update_login = fnd_global.login_id
7970: where repair_line_id = l_rep_line_id;
7971: IF SQL%NOTFOUND THEN
7972: IF ( l_error_level >= G_debug_level) THEN

Line 7969: last_update_login = fnd_global.login_id

7965: set quantity_shipped = 1,
7966: object_version_number = object_version_number+1,
7967: last_update_date = sysdate,
7968: last_updated_by = fnd_global.user_id,
7969: last_update_login = fnd_global.login_id
7970: where repair_line_id = l_rep_line_id;
7971: IF SQL%NOTFOUND THEN
7972: IF ( l_error_level >= G_debug_level) THEN
7973: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 8066: last_updated_by = fnd_global.user_id,

8062: order_line_id = DEL.line_id,
8063: source_serial_number = UT.serial_number,
8064: object_version_number = object_version_number+1,
8065: last_update_date = sysdate,
8066: last_updated_by = fnd_global.user_id,
8067: last_update_login = fnd_global.login_id
8068: where product_transaction_id = l_prod_txn_id;
8069: IF SQL%NOTFOUND THEN
8070: IF ( l_error_level >= G_debug_level) THEN

Line 8067: last_update_login = fnd_global.login_id

8063: source_serial_number = UT.serial_number,
8064: object_version_number = object_version_number+1,
8065: last_update_date = sysdate,
8066: last_updated_by = fnd_global.user_id,
8067: last_update_login = fnd_global.login_id
8068: where product_transaction_id = l_prod_txn_id;
8069: IF SQL%NOTFOUND THEN
8070: IF ( l_error_level >= G_debug_level) THEN
8071: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 8087: last_updated_by = fnd_global.user_id,

8083: Update csd_repairs
8084: set quantity_shipped = 1,
8085: object_version_number = object_version_number+1,
8086: last_update_date = sysdate,
8087: last_updated_by = fnd_global.user_id,
8088: last_update_login = fnd_global.login_id
8089: where repair_line_id = l_rep_line_id;
8090: IF SQL%NOTFOUND THEN
8091: IF ( l_error_level >= G_debug_level) THEN

Line 8088: last_update_login = fnd_global.login_id

8084: set quantity_shipped = 1,
8085: object_version_number = object_version_number+1,
8086: last_update_date = sysdate,
8087: last_updated_by = fnd_global.user_id,
8088: last_update_login = fnd_global.login_id
8089: where repair_line_id = l_rep_line_id;
8090: IF SQL%NOTFOUND THEN
8091: IF ( l_error_level >= G_debug_level) THEN
8092: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 8203: last_updated_by = fnd_global.user_id,

8199: order_line_id = DEL.line_id,
8200: source_serial_number = UT.serial_number,
8201: object_version_number = object_version_number+1,
8202: last_update_date = sysdate,
8203: last_updated_by = fnd_global.user_id,
8204: last_update_login = fnd_global.login_id
8205: where product_transaction_id = l_prod_txn_id;
8206: IF SQL%NOTFOUND THEN
8207: IF ( l_error_level >= G_debug_level) THEN

Line 8204: last_update_login = fnd_global.login_id

8200: source_serial_number = UT.serial_number,
8201: object_version_number = object_version_number+1,
8202: last_update_date = sysdate,
8203: last_updated_by = fnd_global.user_id,
8204: last_update_login = fnd_global.login_id
8205: where product_transaction_id = l_prod_txn_id;
8206: IF SQL%NOTFOUND THEN
8207: IF ( l_error_level >= G_debug_level) THEN
8208: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');

Line 8224: last_updated_by = fnd_global.user_id,

8220: Update csd_repairs
8221: set quantity_shipped = 1,
8222: object_version_number = object_version_number+1,
8223: last_update_date = sysdate,
8224: last_updated_by = fnd_global.user_id,
8225: last_update_login = fnd_global.login_id
8226: where repair_line_id = l_rep_line_id;
8227: IF SQL%NOTFOUND THEN
8228: IF ( l_error_level >= G_debug_level) THEN

Line 8225: last_update_login = fnd_global.login_id

8221: set quantity_shipped = 1,
8222: object_version_number = object_version_number+1,
8223: last_update_date = sysdate,
8224: last_updated_by = fnd_global.user_id,
8225: last_update_login = fnd_global.login_id
8226: where repair_line_id = l_rep_line_id;
8227: IF SQL%NOTFOUND THEN
8228: IF ( l_error_level >= G_debug_level) THEN
8229: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 8322: last_updated_by = fnd_global.user_id,

8318: order_line_id = DEL.line_id,
8319: source_serial_number = UT.serial_number,
8320: object_version_number = object_version_number+1,
8321: last_update_date = sysdate,
8322: last_updated_by = fnd_global.user_id,
8323: last_update_login = fnd_global.login_id
8324: where product_transaction_id = l_prod_txn_id;
8325: IF SQL%NOTFOUND THEN
8326: IF ( l_error_level >= G_debug_level) THEN

Line 8323: last_update_login = fnd_global.login_id

8319: source_serial_number = UT.serial_number,
8320: object_version_number = object_version_number+1,
8321: last_update_date = sysdate,
8322: last_updated_by = fnd_global.user_id,
8323: last_update_login = fnd_global.login_id
8324: where product_transaction_id = l_prod_txn_id;
8325: IF SQL%NOTFOUND THEN
8326: IF ( l_error_level >= G_debug_level) THEN
8327: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 8343: last_updated_by = fnd_global.user_id,

8339: Update csd_repairs
8340: set quantity_shipped = 1,
8341: object_version_number = object_version_number+1,
8342: last_update_date = sysdate,
8343: last_updated_by = fnd_global.user_id,
8344: last_update_login = fnd_global.login_id
8345: where repair_line_id = l_rep_line_id;
8346: IF SQL%NOTFOUND THEN
8347: IF ( l_error_level >= G_debug_level) THEN

Line 8344: last_update_login = fnd_global.login_id

8340: set quantity_shipped = 1,
8341: object_version_number = object_version_number+1,
8342: last_update_date = sysdate,
8343: last_updated_by = fnd_global.user_id,
8344: last_update_login = fnd_global.login_id
8345: where repair_line_id = l_rep_line_id;
8346: IF SQL%NOTFOUND THEN
8347: IF ( l_error_level >= G_debug_level) THEN
8348: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 9216: p_CREATED_BY => FND_GLOBAL.USER_ID,

9212: p_REQUEST_ID => null,
9213: p_PROGRAM_ID => null,
9214: p_PROGRAM_APPLICATION_ID => null,
9215: p_PROGRAM_UPDATE_DATE => null,
9216: p_CREATED_BY => FND_GLOBAL.USER_ID,
9217: p_CREATION_DATE => sysdate,
9218: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
9219: p_LAST_UPDATE_DATE => sysdate,
9220: p_repair_line_id => l_repair_line_id,

Line 9218: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

9214: p_PROGRAM_APPLICATION_ID => null,
9215: p_PROGRAM_UPDATE_DATE => null,
9216: p_CREATED_BY => FND_GLOBAL.USER_ID,
9217: p_CREATION_DATE => sysdate,
9218: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
9219: p_LAST_UPDATE_DATE => sysdate,
9220: p_repair_line_id => l_repair_line_id,
9221: p_EVENT_CODE => l_event_code,
9222: p_EVENT_DATE => sysdate,

Line 9233: p_PARAMN10 => FND_GLOBAL.USER_ID,

9229: p_PARAMN6 => null,
9230: p_PARAMN7 => null,
9231: p_PARAMN8 => null,
9232: p_PARAMN9 => null,
9233: p_PARAMN10 => FND_GLOBAL.USER_ID,
9234: p_PARAMC1 => l_paramc1,
9235: p_PARAMC2 => l_paramc2,
9236: p_PARAMC3 => l_paramc3,
9237: p_PARAMC4 => l_paramc4,

Line 9270: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

9266: p_ATTRIBUTE12 => null,
9267: p_ATTRIBUTE13 => null,
9268: p_ATTRIBUTE14 => null,
9269: p_ATTRIBUTE15 => null,
9270: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
9271: X_Return_Status => x_return_status,
9272: X_Msg_Count => x_msg_count,
9273: X_Msg_Data => x_msg_data
9274: );

Line 9461: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

9457: BEGIN
9458: UPDATE CSD_PRODUCT_TRANSACTIONS
9459: SET PROD_TXN_STATUS = C_PRODTXN_CANCELLED,
9460: LAST_UPDATE_DATE = SYSDATE,
9461: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
9462: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
9463: WHERE PRODUCT_TRANSACTION_ID = l_product_txn_id;
9464: EXCEPTION
9465: WHEN OTHERS THEN

Line 9462: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

9458: UPDATE CSD_PRODUCT_TRANSACTIONS
9459: SET PROD_TXN_STATUS = C_PRODTXN_CANCELLED,
9460: LAST_UPDATE_DATE = SYSDATE,
9461: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
9462: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
9463: WHERE PRODUCT_TRANSACTION_ID = l_product_txn_id;
9464: EXCEPTION
9465: WHEN OTHERS THEN
9466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;